| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting currency symbol in vba
From the Recorder:
Sub Macro1() ' ' Macro1 Macro ' Macro recorded 9/11/2009 by James Ravenswood ' ' Selection.NumberFormat = "[$‚¬-2] #,##0.00" End Sub -- Gary''s Student - gsnu200903 "thomas donino" wrote: Using number formatting you can set a currency symbol in a cell like below for the euro. How is it done in vba? ‚¬ 72.80 |
| 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 new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
| Yen currency symbol | Excel Discussion (Misc queries) | |||
| How do I add a currency symbol | Excel Discussion (Misc queries) | |||
| Currency Symbol | Setting up and Configuration of Excel | |||
Hybrid Mode
