Replace zero with nill

ExcelDude

New Member
Joined
Sep 14, 2006
Messages
8
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!
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

ExcelDude

New Member
Joined
Sep 14, 2006
Messages
8
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

New Member
Joined
Sep 14, 2006
Messages
8
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! :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,113,850
Messages
5,544,660
Members
410,628
Latest member
mike5
Top