![]() |
#1
|
|||
|
|||
![]()
All, I attach (I hope) a very simple petty cash spreadsheet. All entries are either values in GBP and pence - ie only to two places; or additions and subtractions, which should, logically, be limited to two places. None of the entries are caused by division (or multiplication), which could cause values beyond the two places.
I have expanded the column width to show many places of decimals. Can anyone explain why Excel gets its sums wrong? (And then appears to correct itself.) And what can I do about it? Thanks Richard 0 Petty Cash 2015 Mk II.xlsx |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
lynchbro | Excel | 5 | 07-17-2014 11:01 AM |
![]() |
captain_hawkeye | Excel | 1 | 06-14-2010 04:09 AM |
![]() |
markg2 | Excel | 6 | 05-26-2010 09:54 AM |
Formatting financial ratios | jtrobinson | Word | 0 | 01-19-2010 06:46 AM |
![]() |
cubsfan_1 | Excel | 1 | 01-14-2010 06:55 PM |