Most valuable professional
  • Hot Topics

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 2, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel