Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display currency as calculated
Gyus I am just about finished but I can't get Excel to display my currency as
the calculated result. I need to display this accurately so I can take the figures to my accountant. My issue is that when I calculate the GST on an amount, the calc is fine but is displayed in correctly eg $22.63 / 11 = 2.05727272727273, so I need it to display it as $2.05 not as it does - $2.06 (I am sure the taxman would like this printout). I looked at the TRUNC command but can't get it to work. Is there a way to do this in code to a column of numbers where every row has been summed(horizontally), or is there another type of display style I should use. Thanks in advance Gav |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display a loss or gain (currency) | Excel Worksheet Functions | |||
change a currency number display | Excel Discussion (Misc queries) | |||
Display Value in 'Currency Format' | Excel Programming | |||
Failure to display currency format | Excel Discussion (Misc queries) | |||
Formatting a text box to display as currency | Excel Worksheet Functions |