| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable as Currency two decimal places
Hi,
I've defined a variable as Currency. Can I have it display with only two decimal places. This variable is not in a cell. -- Regards, David Lindstrom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable as Currency two decimal places
If you format it
Format(myVar,"#,##0.00") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Max Bialystock" wrote in message ... Hi, I've defined a variable as Currency. Can I have it display with only two decimal places. This variable is not in a cell. -- Regards, David Lindstrom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
variable as Currency two decimal places
Fantastic!
Thanks for your help, Bob, I really appreciate it. -- Regards, David Lindstrom "Bob Phillips" wrote in message ... If you format it Format(myVar,"#,##0.00") -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Max Bialystock" wrote in message ... Hi, I've defined a variable as Currency. Can I have it display with only two decimal places. This variable is not in a cell. -- Regards, David Lindstrom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
| add 2 decimal places | Excel Discussion (Misc queries) | |||
| Text Box Currency format with two decimal places | Excel Programming | |||
Linear Mode
