Converting numbers from exponential 'E+' format
 

I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!

Answer: Converting numbers from exponential 'E+' format
 

Converting Exponential Numbers to Regular Format in Excel

1.

1. Select the cells containing the exponential numbers that you want to convert.
2. Right-click on the selected cells and choose "Format Cells" from the context menu.
3. In the Format Cells dialog box, select "Number" from the list of categories.
4. In the "Decimal Places" field, enter the number of decimal places you want to display (in this case, 0).
5. Click "OK" to close the dialog box.

Your exponential numbers should now be displayed as regular numbers with the correct number of digits. If you want to copy and paste these numbers to another location, make sure to use the "Paste Values" option to avoid pasting the original exponential format.

That's it!

Converting numbers from exponential 'E+' format
 

Select Column. From menu DataText to ColumnsNextNextSelect TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!

Converting numbers from exponential 'E+' format
 

The number is in the text box correctly, so is it not a formatting issue to
make it display in full?

"Jacob Skaria" wrote:

Select Column. From menu DataText to ColumnsNextNextSelect TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!

Converting numbers from exponential 'E+' format
 

How is it displayed when you tried the below..

Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes

If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

The number is in the text box correctly, so is it not a formatting issue to
make it display in full?

"Jacob Skaria" wrote:

Select Column. From menu DataText to ColumnsNextNextSelect TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!

Converting numbers from exponential 'E+' format
 

Quite right, that did work. I shall try it on the rest of the numbers.
It did say it was Polish telephone numbers, so I tried to change that to UK,
but that didn't work.

Many thanks.

"Jacob Skaria" wrote:

How is it displayed when you tried the below..

Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes

If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

The number is in the text box correctly, so is it not a formatting issue to
make it display in full?

"Jacob Skaria" wrote:

Select Column. From menu DataText to ColumnsNextNextSelect TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

I have phone numbers from a report which are in the exponential format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure this must be
straightforward!

Converting numbers from exponential 'E+' format
 

You have to watch out when using anything Polish!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"E" wrote in message
...
Quite right, that did work. I shall try it on the rest of the numbers.
It did say it was Polish telephone numbers, so I tried to change that to
UK,
but that didn't work.

Many thanks.

"Jacob Skaria" wrote:

How is it displayed when you tried the below..

Select ColumnFormatCellsSelect Special and choose OR select CustomIn
Type: enter 11 zeroes

If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

The number is in the text box correctly, so is it not a formatting
issue to
make it display in full?

"Jacob Skaria" wrote:

Select Column. From menu DataText to ColumnsNextNextSelect
TextFinish
OR
Select ColumnFormatCellsSelect Special and choose OR select
CustomIn
Type: enter 11 zeroes
--
If this post helps click Yes
---------------
Jacob Skaria


"E" wrote:

I have phone numbers from a report which are in the exponential
format, eg,
4.5513E+11. I want these to show as 11 digit numbers. I am sure
this must be
straightforward!