Fix phone numbers in scientific notation: turn 1.41555E+10 back into digits
In short: Upload a list, tick the phone columns, and every cell in E+ form is written out as digits, with rows that lost digits marked. Limit: Digits lost before the file was saved cannot be recovered; added zeros are a guess and are marked.
Upload a CSV or .xlsx file, or paste it with a header row. Columns that hold cells like 4.42079460958E+11 are ticked for you, and each such cell is written out as plain digits. Where the notation had cut digits off, zeros are added and the row is marked, because the lost digits cannot be recovered from the file.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
4.42079460958E+11 becomes 442079460958 in full; 1.41555E+10 becomes 14155500000 with 5 zeros added and its row marked.
- Rebuilt in full
- 2
- Rows to check
- 1
- Other cells
- Untouched
What this means for you
Digits cut off before the file was saved cannot be recovered, so marked rows need the source.
- E+ cells written as digits
- Added zeros marked
- Other cells untouched
- Columns picked for you
- E+ notation
- Phones
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Fixed a list that also has email addresses?
- Download the file with its numbers rebuilt.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I turn scientific notation back into phone numbers?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Check the ticked columns: those with cells such as 1.41555E+10 are picked for you.
- Read the counts: numbers rebuilt in full, and numbers rebuilt with added zeros.
- Download the file, and check the marked rows against your source.
Example
- You enter
- Four rows with a Phone column holding 1.41555E+10, 4.42079460958E+11, (415) 555-0132 and 1.2125550100E+10, with the Phone column ticked.
- You get
- 2 numbers rebuilt in full: 4.42079460958E+11 became 442079460958 and 1.2125550100E+10 became 12125550100. 1 number, 1.41555E+10, was rebuilt as 14155500000 with 5 zeros added, and its row is marked to check. (415) 555-0132 is untouched.
- Limits
- Runs in your browser; nothing is uploaded. Digits already lost before the file was saved cannot be recovered; added zeros are a guess.
Why do phone numbers turn into E+ notation?
A spreadsheet reads a column of digits as a number, and long numbers are shown in scientific notation: 14155550132 can appear as 1.41555E+10. Phone numbers are labels, not quantities, so this changes the look without anyone meaning it to.
The trouble is what gets saved. If the file is saved from that display, the text in the file is 1.41555E+10 and the last digits are gone.
Can the lost digits be recovered?
Only if the notation still holds them. 4.42079460958E+11 carries all twelve digits, so it comes back exactly as 442079460958. 1.41555E+10 carries six, so the tool can write 14155500000 but cannot know the last five digits were not zeros.
Those cells are counted as rebuilt with added zeros, and each row is marked in a number_fix_note column. Go back to the original source for them. Spreadsheets also keep only about 15 significant digits, so very long numbers can lose digits even before saving.
How do I stop it happening again?
Set the phone column to Text before pasting or importing. In Excel, use Data, From Text/CSV and set the column type to Text; in Google Sheets, format the column as Plain text. The same applies to ZIP codes and IDs, and the restore leading zeros in CSV tool fixes dropped zeros.
After the fix, put the numbers in one format with the phone number formatter.
Who uses this tool, and for what?
- Sales operations
- Repair a lead export that someone opened and re-saved in a spreadsheet.
- CRM admins
- Fix a phone column before an import that rejects E+ values.
- Marketers
- Recover numbers from an event sheet that was copied between tools.
What can’t this tool tell you?
- Digits lost before the file was saved cannot be recovered; added zeros are a guess and are marked.
- Spreadsheets keep about 15 significant digits, so very long numbers may already be cut.
- It rewrites digits only; it does not format numbers or check them against a country.
- Only the first sheet of a workbook is read.
Common questions
- Will it bring back every digit?
- Only when the notation holds them all. Cells cut short are written with zeros added and are marked so you can check them against the source.
- How do I know which rows lost digits?
- Rows with added zeros get a note in a number_fix_note column, and the count shows above the table.
- Does it change other cells?
- No. Only cells in ticked columns that look like E+ notation change; everything else stays as it was.
- Will Excel break the numbers again?
- It can when it opens the saved file. Import it with Data, From Text/CSV and set the phone column to Text.
- Does it show a number is valid?
- No. It only rewrites digits. Check them with the bulk phone number validator; a number can be well formed and still not in service.
- Is my file uploaded?
- No. It is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.