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:
- Microsoft Excel