View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
E[_2_] E[_2_] is offline
external usenet poster
 
Posts: 40
Default 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!