Hello. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a bit of an issue where the spreadsheet I am using has a number of different currencies with no identifying means other than the formatting of the cell. <o></o>
<o></o>
So, for example I have a column of figures that contain:<o></o>
£100.00<o></o>
100.00 EUR<o></o>
$100.00<o></o>
100.00 NOK<o></o>
<o></o>
Obviously, that means the cell value is 100 in each case. <o></o>
<o></o>
Is there a function I can use which will allow me to determine currency in the cell by looking at the format of the cell? <o></o>
<o></o>
I am trying to convert all into $ so I need to be able to show what they are. <o></o>
<o></o>
I am using Excel 2000 and all help is much appreciated. <o></o>
Many thanks
G12
<o></o>
I have a bit of an issue where the spreadsheet I am using has a number of different currencies with no identifying means other than the formatting of the cell. <o></o>
<o></o>
So, for example I have a column of figures that contain:<o></o>
£100.00<o></o>
100.00 EUR<o></o>
$100.00<o></o>
100.00 NOK<o></o>
<o></o>
Obviously, that means the cell value is 100 in each case. <o></o>
<o></o>
Is there a function I can use which will allow me to determine currency in the cell by looking at the format of the cell? <o></o>
<o></o>
I am trying to convert all into $ so I need to be able to show what they are. <o></o>
<o></o>
I am using Excel 2000 and all help is much appreciated. <o></o>
Many thanks
G12