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/...soft_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

"Horizon" wrote in message
...
If there is data is a column of cells in Excel how do I insert/add
additional
data (000) in front of each cell?