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

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?