Forum Discussion
Solved
OS windows 2010 windows 365 excel
I have a column of numbers of 2 and 3 digits, I like to have leading zeros for the 2 digit 45 65 789 Need to add leading a zero to 45 and 65
See the attached workbook - it assumes that you have Office 2019 or Microsoft 365.
Hello, I really appreciate your answer and that worked. Just not sure how to paste on down the column with the formula.
And what if I wanted to paste 2 digit numbers so it will autofill to 3 digits verses having a predefined text spreadsheet?
thanks
Greg Dupree@hteeter
Drag down the fill handle in the lower right corner of the first cell with the formula to copy the formula to the cells below.
If you want to convert 2 digits automatically to 3 digits, that would require VBA code. Would that be acceptable? (macros won't work in the online, iOS and Android versions of Excel)
- Hi,
no its not converting, just adding the leading zero to 2 digit character
I'm thinking I would key to this formula, I have 50 cells
paste numbers into column 1 , separate each with comma and then transpose to 10 numbers per row. Not sure how to transpose the rows
=TEXT(A1:A50",000")I'm afraid you've lost me.
- sorry about the confusion and thanks for the help
I have hundreds of numbers; 2 and 3 digits, to run my program correctly, each digit must be 3 digits and separated by commas; like 002,006,012,455,217,009, etc.
so my text file have hundreds; 3,2,122,08, etc. I would like to paste them in excel, add leading zeros for 3 digits, but I can only have 10 numbers per line in the program.
can the formula apply to a row?