Having zero's entered as dashes in Microsoft Excel?

0 ⤊

Quick question. How do you get "0" values to be seen as a "-" in Microsoft Excel?

format the cell (click on the cell and rightclick and pick format). Format it in "accounting method" with no symbols.

2006-08-01 03:48:09 · answer #1 · answered by miketorse 5 · 0⤊ 0⤋

Just click on the comma style , on the tool bar.

2006-08-01 05:03:33 · answer #2 · answered by Thrasher 5 · 0⤊ 0⤋