We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel Negative 0 help
pmartin86
Posts: 776 Forumite
Hi
i run a spreadsheet in excel to track all my accounts and keep everything in once, however a minor irritating thing that happens is when a balance is reduced to 0, it displays as "-£0.00" I was wondering if anyone knew how to force excel to treat "0.00" as a positive rather than a negative?
The only way I can think of is to force all negative values to display as 0, but as i work with both positive and negative balance I need to see both.
Regards
Paul
Edit: Never mind, after a bit more rooting around and playing I found a way of forcing excel to display them properly, link below if anyone else requires this info.
http://excel.tips.net/T002576_Getting_Rid_of_Negative_Zero_Amounts.html
i run a spreadsheet in excel to track all my accounts and keep everything in once, however a minor irritating thing that happens is when a balance is reduced to 0, it displays as "-£0.00" I was wondering if anyone knew how to force excel to treat "0.00" as a positive rather than a negative?
The only way I can think of is to force all negative values to display as 0, but as i work with both positive and negative balance I need to see both.
Regards
Paul
Edit: Never mind, after a bit more rooting around and playing I found a way of forcing excel to display them properly, link below if anyone else requires this info.
http://excel.tips.net/T002576_Getting_Rid_of_Negative_Zero_Amounts.html
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards