View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dodie dodie is offline
external usenet poster
 
Posts: 1
Default why does Excel convert 63781403840072 to 6.37814E+13 & how prevent

I do a concentate on a number of cells and Excel comes up with a number like
63781403840072

it converts to 6.37814E+13

I have a quite a few numbers like this.

is there a quick way to convert back to the number without editing each one
and adding a ' in front?