Scientific Formatting

Good afternoon all

I am processing data for a client of mine which includes account numbers.

The majority of account numbers are fine when I export them, but there are a few which are showing as "7.009E+55" for example. I know this happens sometimes if the number is a long number, but this is not the case here, the actual account number is "7009E52". Looking at the data, this problem seems to appear whenever the account number includes the letter "E", as all the account numbers are a numbers with 1 letter, but only the "E" is causing this issue.

Any ideas how I resolve this please?

Kind regards,

Craig Kinsey

To add one thing. If you're talking about exporting from another program into Excel you could try exporting as a text file instead and then import into Excel using that. Then, you can define the format of each individual column and can bring that field in as text to avoid conversion to scientific notation.

@Craig.... Do not open the CSV file directly in Excel. Instead, import it by clicking Data > From Text. In the Step 3 of the Text Import Wizard, select the column with account IDs and select Text for "Column data format".

Otherwise, Excel interprets data just as if we typed it into a cell manually. When we type 7009E52, Excel interprets that as the number 7009E+52, which it formats as 7.009E+55.