Excel: Adding digits to the right of a number so they are all 10 digits long


hi there i found this thread which nearly answered my question - but i can't get it to work sadly i have a very long (thousands) string of sequential numbers like this (which is data over time)

3701041667
3702777777
3704513889
3705671296
370625
3706828704
3707638889
I need to make all the numbers the full 10 digit string long - so the 370625 number into 3706250000 (and others like him that even shorter the full ten digits) because it is a very long column (2389 lines long) i guess it is consideration that the formula works the entire length of the column i would really appreciate help with this. i am a total excel newbie - an animator actually (wish my dad was still alive he was a hotshot!)


This question generated 15 answers. To proceed to the answers, click here.

This thread is current as of June 02, 2017.


For more resources for Microsoft Excel