Re: 'Text' formatted cells displaying numbers in scientific format

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Excel has a 15 digit precision limit
Try formatting the receiving cell as Text before importing
Or arrange to have a single quote in front of the long string of digits
before the import
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"plegron" <plegron@xxxxxxxxxxx> wrote in message
news:eZ43S0AEIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx
I use Excel to view statement information downloaded from my bank in CSV
format.

As some fields have long numeric strings that Excel displays in scientific
notation (4988243043081440 displays as 4.98842E+15), I use Copy > Paste
Special > Values to copy the data to a new *** which is correctly
formatted in order to view the data correctly as text.

Despite this, some cells still display the numeric string in scientific
notation. Selecting the cell shows that it's already correctly formatted.
Applying the change again or changing it then changing back makes no
difference, however opening the cell for editing (F2) then exiting forces
the cell to display correctly.

What's going on and why does it affect some cells and not others?

How can I prevent this from happening?




.

Quantcast