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

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!