Number format question

Topic

New Reply

I have a sheet where I use this custom number format ( 0;-0;;@ ) to hide zero values in selected cells.

It works fine, however when I enter a value in one of the selected cells, I need the cell to display 2 digits after the decimal. I cannot figure out how to modify this format to do this.

Any help is appreciated.

Reply | Quote

Replies

Try ( 0,00;-0,00;;@ )

Reply | Quote

Leif,

You got it except OP is in the US so it would be {0.00;-0.00;;@} :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote