View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nate Pickett Nate Pickett is offline
external usenet poster
 
Posts: 1
Default Auto-Formatting in Excel: changing values

Hi,

I am wondering if anyone knows a way to avoid excel from auto-formatting
data and changing the values of the data. For ex. my .csv file contains the
following data:

Testing 0E0, 0E0

and is displayed in excel as:

Testing 0E0 0.00E+00

Please find example file attached. Thanks!