Hello. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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
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
So, for example I have a column of figures that contain:<o
£100.00<o
100.00 EUR<o
$100.00<o
100.00 NOK<o
<o
Obviously, that means the cell value is 100 in each case. <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
I am trying to convert all into $ so I need to be able to show what they are. <o
<o
I am using Excel 2000 and all help is much appreciated. <o
Many thanks
G12