Felix Atagong
Active Member
- Joined
- Jun 27, 2003
- Messages
- 359
I have a list of numbers, these are all currencies, although not all numbers are formatted as currency. The numbers are in the European format, thus a decimal point is in fact represented by a ,
If no currency formatting is put inside the cell, the currency is Euro.
But some cells have a currency symbol in front of them and I need to find out WHAT currency that is. The cells in question are not text, they have been formatted as currency, so I can't use the 'left' function to find out the first letter.
2345,67
$1.234,56
3456,78
£8765,43
€8513,94
So I need to know that cell 2 is dollars, cell 4 is pounds and cell 5 is euro... It should be extremely simple I guess, but I just can't find it...
If no currency formatting is put inside the cell, the currency is Euro.
But some cells have a currency symbol in front of them and I need to find out WHAT currency that is. The cells in question are not text, they have been formatted as currency, so I can't use the 'left' function to find out the first letter.
2345,67
$1.234,56
3456,78
£8765,43
€8513,94
So I need to know that cell 2 is dollars, cell 4 is pounds and cell 5 is euro... It should be extremely simple I guess, but I just can't find it...