Expand an E+ code back into digits
Turn the text 1.23456789E+09 into 1234567890, when every digit is still there.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The code written in E+ form, as text. | "1.23456789E+09" |
| 2 | VALUE( … ) | Reads the text as a number. | 1234567890 |
| 3 | "0" | The pattern: whole number, every digit. | "0" |
| 4 | TEXT( … ) | Writes the number out in full as text. | "1234567890" |
| 5 | IFERROR( … ) | Shows Review numeric code if it can't be read. | "1234567890" |
Each bracket wraps the one above it, so Excel works from the inside out. The codes here are made-up.
=IFERROR(TEXT(VALUE(A8),"0"),"Review numeric code")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own codes. Paste codes like 1.23456789E+09 into the green column of the Template tab. The full codes fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This can't bring back digits an export already cut off, or zeros at the front. Check those codes against the source.
Microsoft's help: VALUE function
OTHER ROUTES YOU MIGHT LIKE

Remove a leading apostrophe from an ID
'000123 → 000123
Get the template →
Return a short stored ID as text
123 as a number → 123 as text
Get the template →
Keep missing-ID markers blank
NULL → blank; 000000001 → 000000001 (zeros kept)
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →