| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying Currency numbers (e.g. "CAD 1,999") on worksheet
Hi there,
instead of programming Cells(Row,Column) = Number(1) where Number(1) = 1999 I would like to indicate numbers as different currencies and make us of a comma as the "1000 Separator". For example, "1999" should be written as "CAD 1,999". How could I program this? What are the commands to use? Thank you for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
| Worksheet not displaying "Sum" in lover right corner | Excel Discussion (Misc queries) | |||
| Formating numbers &"Text" to appear as currency &"Text" in formula | Excel Discussion (Misc queries) | |||
| In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
| Changing format of column from "general" to "currency" | Excel Programming | |||
Threaded Mode
