| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use Local Currency Symbol
I am feeling pretty dumb today.
I cannot for the life of me see how to format a cell so that the number will appear using the Currency Symbol specified in the Regional and Language settings in the Control Panel. I want the currency symbol to change based on the regional settings, so if the user is in Australia they will see $2.50 and if in the UK the will see £2.50 If I format a number as currency and specify the currency symbol as $, $ still displays when I change the regional settings to UK. TIA Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to add new currency symbol | Excel Discussion (Misc queries) | |||
| How to add currency symbol to a cell value | Excel Discussion (Misc queries) | |||
| How do I add a currency symbol | Excel Discussion (Misc queries) | |||
| Looking a formula to convert local currency to USD by matching com | Excel Worksheet Functions | |||
| Currency Symbol | Setting up and Configuration of Excel | |||
Threaded Mode
