Brazilian currency format to US currency format

[chartee]

I have lists of checks with values in the format XXX.XXX,XX which is the Brazilian (and other countries, I am sure)currency format. I need to convert this to XXX,XXX.XX or US currency format. Right now, Excel reads the number in the cell as text and I need it to be numeric. Any suggestions?

Thanks much

 

[misscrf]

OK, this took some playing around, but I think this might work.

You need to open a new workbook, or worksheet, and format the cells that you WILL put data in. You must do this before you put the brazilian data into them.

You select the cells, and right click, and go to format cells, in the number tab, pick currency, and go all the way down to Portuguese (Brazilian)

Then paste or import your data to those cells.

Then you can convert them all to American currency by formatting all of those cells, with the now Brazilian currency, and choose the $ for the currency. This will reformat them for you.

Good luck

misscrf

Management is doing things right, leadership is doing the right things

 

[SkipVought]

Hi,

Change your regional settings for Decimal Symbol and Digit Grouping Symbol.

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[SkipVought]

or...

since Excel is treating your numbers as TEXT use Edit/Replace to...

1) Replace [Decimal] with NOTHING
2) Replace [Comma] with [Decimal]


Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]