Converting numbers from exponential 'E+' format

[E]

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!

 

[E]

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

 

[Jacob Skaria]

How is it displayed when you tried the below..

Select Column>FormatCells>Select Special and choose OR select Custom>In
Type: enter 11 zeroes

If this post helps click Yes

 

[E]

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.

 

[Ragdyer]

You have to watch out when using anything Polish!<bg>