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

In Excel: 1.23456789E+09 becomes 1234567890.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The code written in E+ form, as text."1.23456789E+09"
2VALUE( … )Reads the text as a number.1234567890
3"0"The pattern: whole number, every digit."0"
4TEXT( … )Writes the number out in full as text."1234567890"
5IFERROR( … )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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. 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.
  3. 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