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

D

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?
 
M

Mike H

Hi,

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

Mike
 
D

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.
 
Top