Display 0 as 000

[dcofer]

Hello All,

I need some help again.

I have a column of numbers and I need to display all the zeros as "000" instead of "0".

I tried the custom format of ###, but it changed my two digit numbers so they had a leading zero (32 became 032). I do not want to change any numbers other than the zeros, which need to be displayed as "000".

I also used the format of "000" but it did the same thing to my one and two digit numbers by giving them a leading zero, which I do not want. Control Find & Replace also failed to work.

Any ideas?

Thanks in advance for your help.

David

 

[shg]

Try 0;-0;000

 

[dcofer]

SHG,

Thaks!!!

That worked perfectly.

David