Thu 10 Oct 2019, 16:36Delegate Clare said...
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
Sat 12 Oct 2019, 17:04Trainer Marius said...
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
