Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding a zero to the front of numbers
I have a column of numbers, over 800 rows. Some numbers are 7 digits and
some are 6 digits. I need a zero at the beginning of all the numbers with 6 digits. I have formatted the column to text so that I can do this because it's not important that this column be recognized in number format. However, is there a formula I could use to drag down the entire column that would pick out all the numbers with 6 digits and throw a zero at the beginning of the number? I'd hate to have to do this manually! Thank you. Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help in adding a ' in front of a column of numbers | New Users to Excel | |||
Replacing last 3 characters and adding them to front | Excel Discussion (Misc queries) | |||
adding digits to front/end of fax numbers | Excel Discussion (Misc queries) | |||
adding a zero in front of number | Excel Discussion (Misc queries) | |||
Adding + in front of a number | Excel Discussion (Misc queries) |