I have currency data which is stored in Euopean currency
and I want to format it to dollars on a regular basis. Is
there an easy way for Excel to do this?. I have tried
formatting cells and replacing characters by search and
replace, but this is bit hit and miss. The data is stored
as 1.234,56 and I want to convert it to 1,234.56

Mark
In Excel, click on Tools/Options, then the International tab. The top section is "Number handling", and you can specify what you want to use as decimal and thousands separators. Click on the Use system separators box to remove the check mark, and then you can choose your own separators
Jil

----- Mark wrote: ----

I have currency data which is stored in Euopean currency
and I want to format it to dollars on a regular basis. Is
there an easy way for Excel to do this?. I have tried
formatting cells and replacing characters by search and
replace, but this is bit hit and miss. The data is stored
as 1.234,56 and I want to convert it to 1,234.5