ExcelBanter - how to display zero as dashes in worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to display zero as dashes in worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/168731-how-display-zero-dashes-worksheet.html)

hbee

how to display zero as dashes in worksheet

how to display zero as dashes in worksheet?

JE McGimpsey

how to display zero as dashes in worksheet

One way:

Format/Cell/Number/Custom: General;General;"-";@

In article ,
hbee wrote:

how to display zero as dashes in worksheet?

Gord Dibben

how to display zero as dashes in worksheet

FormatCellsNumberAccounting with Symbol set to "none".

Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 09:34:02 -0800, hbee wrote:

how to display zero as dashes in worksheet?

All times are GMT +1. The time now is 11:16 AM.