Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHY IS MY CURRENCY SUM ONE PENCE OUT?
im am trying to add cells that are formatted to currency but cant understand
why it is 1p out? the cells i am adding have a minus formula in them! the first five cells add up correctly but if i go over that the sum is 1p out? can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect Currency Displayed | Excel Discussion (Misc queries) | |||
Pence field to currency? | Excel Worksheet Functions | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |