Excel automatically changing my column with "E" to exponential Num
How do you 'convert' data to Excel?
You need to define the column as TEXT while importing...
For data already imported -
Try selecting the column, choose Data|Text to column and choose TEXT as the
column type...
"Plukey2" wrote:
We transfer data from a database to Excel for multiple reasons. The ID to
our records are 6 characters such as "123A12" "456B12". When we have an ID
such as "419E07" Excel automatically changes that to 4.19E+09. A group of
us has tried EVERYTHING we know to stop this from happening. When we open
Excel, we DO NOT want Excel to convert. Any ideas?
|