Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to handle multiple currencies with one spreadsheet
I have one spreadsheet that I need to send to people in different countries.
I would like each user to open the spreadsheet and see their currency code - Dollars, or Euros, or Yen, automatically formatted based on the region or country. How can I make sure that the spreadsheet displays the correct currency format based on the region or country where the user is located - and not the currency format that the spreadsheet was created in? |
#2
|
|||
|
|||
You could save several versions of the same file ("file name" Yen, "file
name" Euro, etc.) or, you could record macros to reformat the currencies and attach them to buttons on the spreadsheet. "Michael Mullican" wrote: I have one spreadsheet that I need to send to people in different countries. I would like each user to open the spreadsheet and see their currency code - Dollars, or Euros, or Yen, automatically formatted based on the region or country. How can I make sure that the spreadsheet displays the correct currency format based on the region or country where the user is located - and not the currency format that the spreadsheet was created in? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
can I put a multiple worksheets within a worksheet(s) in a spreads | Excel Discussion (Misc queries) | |||
How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |