I'm using "paste special" to copy a concatenated cell into another cell.
When I do this it changes the last 3-4 digits to zeros instead of keeping the
correct numbers. Why is it doing this?

Thanks!

Robin

While the data is 'text' you can, within very loose limits, have as many
characters as you like. As soon as you change this to a number, Excel will
only work with 15 digits, the remainder being changed to zeroes.

If you have these formatted as text then use paste specialvalues and number
formats

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Robin" wrote in message
...
I'm using "paste special" to copy a concatenated cell into another cell.
When I do this it changes the last 3-4 digits to zeros instead of keeping
the
correct numbers. Why is it doing this?

Thanks!