I stand corrected. thanks,

"John Green" wrote in message
...
From the menu select Tools|Options. Click on the View tab and remove the
check against "Zero values". Zeros will now display as
blanks.



--

John Green - Excel MVP
Sydney
Australia


"Sandy Ferguson" wrote in message
m...
I have a number of worksheets with many 0 cells. I wish to replace the
0 cells with blank. If I use replace 0 with blank it also changes the
10,20 etc to 1,2 by removing the 0. I have tried searching for 0 with
a leading blank, using various functions & just about run out of
ideas. I am NOT an Excel expert & would appreciate any help