formatting cells

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formatting cells

Formatting cells

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips


Server loaded in 0.13 secs.