Matthew Ingram
New Member
- Joined
- Jun 2, 2017
- Messages
- 9
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)
<colgroup><col width="306" style="width:230pt"> </colgroup><tbody>
</tbody>
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!)
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 |
<colgroup><col width="306" style="width:230pt"> </colgroup><tbody>
</tbody>
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!)