Approx. 115,000 records are being exported from a new software system. I'm
creating 6 smaller files from the large file based on the district they are
from. I'm then creating a spreadsheet for each file. Each line of the
spreadsheet will have an ID value in column A. Each line will have values in
either columns B,C,&D or E,F,"&G. If B&C or E&F are blank, I cannot have a 0
in D or G, which is happening now. When the spreadsheets are finished they
will be saved as a DBF file and the information will be used on a web site.
Random 0's are not acceptable. I can find and replace, but I would prefer to
use an embedded function.

"Gord Dibben" wrote:

What is your aim?

To not see the zeros?

Do not replace with a space. That will cause you problems down the line.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 13:58:37 -0700, Mike
wrote:

For all cells in a column, E2 - E20, that contain a value of 0, how can you
change the value to a space while making no changes to cells containg a value
0?