View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mitch
 
Posts: n/a
Default Missing values from SAS

I found the answer myself. You just select the "Match Entire Cell Contents"
option. Thanks anyway!

"Mitch" wrote:

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?