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

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?

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.

Hope that help,

Chris


--
cbh35711
------------------------------------------------------------------------
cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276
View this thread: http://www.excelforum.com/showthread...hreadid=501802