Thread: Convert e+ e- to number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn Kevin Vaughn is offline
external usenet poster
  
Posts: 111
Default Convert e+ e- to number
Try making your column wider.
--
Kevin Vaughn


"Elisabeth" wrote:

How can I convert a number 1,234E+06 into 1234000 without having to rewrite
all the values in my dataset?

Reply With QuoteReply With Quote