View Single Post
  #2   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

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!