Yes, if you convert it to a number you'll be hit by Excel's limitation to 15
significant figures. It you want more sig figs than that, then leave it as
text.
--
David Biddulph

"DavCan" wrote in message
...
Here are the steps I am performing
I am concatinating 2 numeric fields.
Copy Paste Special Values - This then makes the result text
A warning box comes up and I click on it and specify to convert to number
When it converts the result, it formats it to Scientific notation
I then format it to Number with zero decimals
This then changes the last digit to 0.
910000026 1370735 is what I begin with 9100000261370730 is what I end up
with