Two ways. If all cells should be the same length, like a check number or an
account number, it's called "leading zeroes": http://www.officearticles.com/excel/show_leading_zeroes_in_microsoft_excel.htm
If you just want to put 3 zeroes in front of other text, you can use another
column to create a formula:
="000"&a1
will give you the contents of A1 preceded by 3 zeroes.
************
Hope it helps!
Anne Troy www.OfficeArticles.com
Insert a column before it, and fill it with "'000", don't forget '
Then concatenate those two rows, that should do it.
You can copy paste values and delete the other two columns to get it
back to the same way it was before. If you click into it will take
your 0s away, not fair I know. You won't have that problem if you keep
the formulas there.
