Problem with concatination result. Last digit change to 0

[DavCan]

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

 

[David Biddulph]

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.