why does Excel convert 63781403840072 to 6.37814E+13 & how prevent

[dodie]

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?

 

[Mike H]

Hi,

Format the cell as 'number' and if you want set the decimal places to zero

Mike

 

[David Biddulph]

Format as number with zero decimal places.
Wouldn't work for more than 15 digits, of course, as Excel's numbers are
limited to 15 digits, but for your example, not a problem.