I have a spreadsheet that has 1,00’s of cells all formatted to GBP. I want to write a macro that goes thru and changes every cell in the workbook from GBP to USD. Is this possible?
There is no need for Macro, but you have to clearify:
- which Numberformatcode exactly is supplied?
- is the Numberformat provided by CellStyle? or not?
additional:
- do you need also to recalculate the values by some Exchange-rate (which exactly?) from GBP to USD
It is the built-in currency format for GBP-english UK
No, it is the cell format–currency–drop down–GBP-english UK
No, I just want the file to be in USD format and I don’t want to have to find every cell and change by hand.
please note this is an intenational Forum not everbody knows by heart which default-Currency-format is used in UK!
Ok
→→Edit→Find and Replace
Find: £.*
[x]formatted Display [x]all Sheets
other options:
[x]regular Expression
hit →→Find All
after →right click→→Format Cells … and change →Numbers→Format to whatever you want.
Make sure you right-click on one of the cells still marked from the Find, otherwise the selection is removed and you’ll have to repeat… also, format replacement does not work for individual selections on multiple sheets, so don’t use All sheets, but instead repeat on each sheet.
1 Like
… or do not right-click, but instead, use menu Format|Cells.
1 Like
Or close the dialogs by hitting Escape for each and then Ctrl+1 to get the formatting dialog.
