| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use Local Currency Symbol
currencycode = Excel.xlCurrencyCode
In the VBA help menu type currency. Then look under "International Property" and "format currency function". It look like you have to get the International property and then format the cells using format currency function. "Tony Starr" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
