Hi,

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

Mike

"dodie" wrote:

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?