I am doing a spreadsheet in excel for a client who likes zero to be displayed as a dash rather than blank or zero. I can't seem to get it to display a dash and there is nothing in "help" that I can find. Any ideas?
Nicola Stone
Replies (9)
Please login or register to join the discussion.
Tony
I think you'll find that your suggestion is remarkably similar to my earlier posting, except you don't need all those quote marks.
How about this
This one seems to work for me:
#,###_);(#,###);-_)
I guess you missed off the zero definition from your custom format.
Dashes as zeros
I just press the spacebar before and after the dash! It can then be left, right or centre justified.
I use this for accounts etc., it leaves one space between dash and edge of box, so you can't use if this is a problem for your presentation.
I forgot...
Thanks for the suggestions but I should have mentioned that the rest of the spreadsheet has a defined number format which includes brackets for negative numbers (and an extra space for positive numbers so they align correctly). So I can't use either of those options unfortunately!
Use Accounting number format
First of all highlight the range you need to alter. Go to the Format menu and select Cells. Select Accounting from the category list. The symbol section automatically comes up with £. Change this to None and click OK.