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?

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?

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.
--
David Biddulph

"dodie" wrote in message
...
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?