ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto-Formatting in Excel: changing values (https://www.excelbanter.com/excel-programming/295991-auto-formatting-excel-changing-values.html)

Nate Pickett

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!






All times are GMT +1. The time now is 08:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com