Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Look what really is in the cell, not what's visible, if you have a formula
copy the cell, paste special as values in an empty cell and look in the formula bar what the result really is, if you have currency formatted with 2 decimals it will display a rounded result but the underlying value might be different see: http://www.mcgimpsey.com/excel/pennyoff.html Regards, Peo Sjoblom "Hazeldean" wrote: After instal of Office SP3, I now find that Excel rounds simple formula results up or down when visually the correct answer should be the opposite |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) | |||
Can I stop rounding in excel? | Excel Discussion (Misc queries) | |||
Amount or Numbers in Words | New Users to Excel | |||
Spellnumber | Excel Worksheet Functions | |||
stop excel from shifting cells up when a query returns no data | Excel Worksheet Functions |