Hi ,
Please note that before you say that you have a currency value in a particular format , you should verify that what you have is a numeric value.
A format is purely visual ; thus a date can be displayed as Saturday , which is a text string , but when you place the cursor in the cell which displays Saturday , what you see will be a date ; if you convert the cell format to General , what you see will be a number. If you do not see a number , then what you have is not a valid date.
Another fool-proof way is to use the TYPE function , which will return 1 if a value is numeric , and 2 if it is text.
So if a value is text , no cell format will ever convert it to numeric ; the same holds true the other way around. Cell formatting is only going to change the way data is displayed , but the underlying nature of the data will not change. So , if you have a text string in a cell , and you want it in currency format , the only way is to change the nature of the cell contents , either using a formula , or using VBA , or even by the Copy -> PasteSpecial -> Multiply route.
Narayan
