Excel 2007 - Conditional Currency format
Posted
by glinch
on Stack Overflow
See other posts from Stack Overflow
or by glinch
Published on 2010-06-06T16:36:05Z
Indexed on
2010/06/06
16:42 UTC
Read the original article
Hit count: 397
excel
|excel-2007
Hi there,
Is it possible to set the currency of a column (£ / € / $) dependent on the value of a cell?
Eg, If i determine that the address im using in the workbook is America the workbooks currency will be set to dollars.
This would save the time of having multiple spreadsheets for different currencies.
Thanks in advance to anyone who can help.
Noel
© Stack Overflow or respective owner