98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting cells
Formatting cells
Resolved · Low Priority · Version 2016
Clare has attended:
Excel Intermediate course
Excel Advanced course
Formatting cells
How do I show - instead of 0 in cells (almost like accounting format with no symbols) but centred - I can only get it aligned to the right
RE: formatting cells
Hi Claire,
It was nice meeting you on Thursday. I have found a solution:
In your selected cells, open Format Cells and select Custom. In the Type box, type #;-#;-
Positive and negative numbers will stay unchanged and zeros will show as -
I hope this helps.
Kind regards
Marius Barnard
STL
Sat 19 Oct 2019: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Date and timeCTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON |