Replace zero with nill

[ExcelDude]

I know how to replace zero with nill, but how do I get it to replace ONLY zero, and not a zero in a number such as 109 which turns to 19. Seems simple, but I'm not getting it!

 

[Richard Schollar]

Hi

You could use a custom format like:

0;-0;"Nill"

Best regards

Richard

 

[ExcelDude]

That didn't seem to work, it took away the zeros from site, but they are still in the cell. I need them out so I can average w/out the zeroes, and without changing my formulas which are numerous.

 

[ExcelDude]

I got it, if anyone is interested. IN the replace wizard there is a box you can check that states "Match Case" or "Match entire cell contents". By clicking the latter it replaces zero only with nothing rather than turning something like 109 into 19. Yeah!