zero values

Guest · Apr 26, 2004

How do you get a zero value to appear as a dash instead of
a zero?

Don Guillett · Apr 26, 2004

formatting>formatting>that is the future.
Seriously, format with ACCOUNTING.

Frank Kabel · Apr 26, 2004

Hi
apply the following custom format to this cell:
0.00;-0.00;-

zeros show as dashes in spreadsheet, want to show 0.	2	Jun 16, 2009
Displaying zeros in cells	2	Sep 9, 2021
Formatting zeros as dashes	4	Dec 17, 2009
number format	2	Mar 12, 2009
Custom format Numbers	2	Mar 4, 2010
Value manipulation	3	Apr 3, 2009
Custom number format thousands and zeros as "-"	1	Mar 4, 2010
Need to change numbers with dashes to numbers with no dashes	3	Nov 3, 2009

Ask a Question