View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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!