| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Currency Formatting to 3 decimal Places
Hi,
Help, please. Open a new worksheet, and place $1.000 in cell A1 (Currency format, please note three decimal places). With the macro: ------ Sub HelloWorld() Cells(1, 1).Value = Cells(1, 1).Value + 0.011 End Sub ----- The result is $1.010, not $1.011. I'm sure this has been addressed before... but how can I can three or more decimal places out of the currency format. Online help refers to turning the variable to ccur or @, but I'm a clueless wanderer. Thanks David Dalebroux |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Currency Formatting to 3 decimal Places
David,
Use the Value2 property. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "David Dalebroux" wrote in message m... Hi, Help, please. Open a new worksheet, and place $1.000 in cell A1 (Currency format, please note three decimal places). With the macro: ------ Sub HelloWorld() Cells(1, 1).Value = Cells(1, 1).Value + 0.011 End Sub ----- The result is $1.010, not $1.011. I'm sure this has been addressed before... but how can I can three or more decimal places out of the currency format. Online help refers to turning the variable to ccur or @, but I'm a clueless wanderer. Thanks David Dalebroux |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditonally formatting decimal places | Excel Discussion (Misc queries) | |||
| decimal places in currency | Excel Programming | |||
| variable as Currency two decimal places | Excel Programming | |||
| Text Box Currency format with two decimal places | Excel Programming | |||
| Conditional Formatting - number of decimal places | Excel Programming | |||
Linear Mode
