Norman Potting
Well-known member
- Thread starter
- #21
Thanks for all your suggestions - will try later today and report back. Another thought - anyone got a copy of Lotus 123 I could borrow 
[Help] Irritating Excel conundrum
- Thread starter Norman Potting
- Start date
Got something to say or just want fewer pesky ads? Join us... 😊
Changing the decimal places using the buttons doesn't actually change the value, it just changes how it appears. So if the cell is referenced in another formula, the original non-rounded value is used.
Whereas the ROUND function actually modifies the value.
Sent from my SM-J530F using Tapatalk
Official Old Man
Uckfield Seagull
I use LibreOffice Calc but it is very similar to Office.
In the 'sum' box where you're adding up figures for takings in £'s, open up Format Cells. Mine is set to
Category - Currency
Format - -£1234.00
Decimal places - 2
Leading zeroes - 1
It's the Format or Decimal Places that may be at fault.
In the 'sum' box where you're adding up figures for takings in £'s, open up Format Cells. Mine is set to
Category - Currency
Format - -£1234.00
Decimal places - 2
Leading zeroes - 1
It's the Format or Decimal Places that may be at fault.
WildWood
Well-known member
As it’s nearly Christmas an’ all.....
Norman Potting
Well-known member
- Thread starter
- #25
Chaps and chapesses. The winning entries to this thread are those that alluded to the "Round" function, in particular Mr., Mrs. or Ms. "Lets Have A Winner" who has helped me out via a rare post. Thanks to all of you who took the trouble to post your suggestions, I now have a spreadsheet that looks correct and with numbers that agree with me adding them up on a calculator!
The worrying thought is that I would probably have spent far less time knocking up a table in Word and doing the calculations manually
The worrying thought is that I would probably have spent far less time knocking up a table in Word and doing the calculations manually
Let's Have A Winner!
Active member
Chaps and chapesses. The winning entries to this thread are those that alluded to the "Round" function, in particular Mr., Mrs. or Ms. "Lets Have A Winner" who has helped me out via a rare post. Thanks to all of you who took the trouble to post your suggestions, I now have a spreadsheet that looks correct and with numbers that agree with me adding them up on a calculator!
The worrying thought is that I would probably have spent far less time knocking up a table in Word and doing the calculations manually
It's Mr and you're very welcome sir! I am on Excel pretty much all day every day at work so know a lot of the quirks and tricks to get round them (no pun intended
)...