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)
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