You could write code to loop through the cells and using an if statement
test if worksheets(1).range(CellVariable).value2 = "."


"Mitch" wrote in message
...
I am forced to work with an Excel sheet that was imported from SAS. It
contains the standard period "." in all cells where the data was missing.
I
cannot rerun the SAS to eliminate the missing data marks. Is there a way
to
eliminate the "." in Excel without also eliminating the decimal point in
numeric cell values?