This is NOT a formula. It is a macro that must be copied into a module and
executed.

Just tested. Notice the ' before the 0

Sub addzerotostartofcell()
For Each c In Range("c3:c" & _
Cells(Rows.Count, "c").End(xlUp).Row)
c.Value = "'0" & c
Next c


--
Don Guillett
SalesAid Software

"Jannie" wrote in message
...
My column data starts in cell C3. I tried this formula but I don't think
I'm
saying it right. Could you please write it out exactly like I should say
it
so I understand exactly what you mean. Thanks.

"Don Guillett" wrote:

try this

for each c in range("a2:a"&cells(rows.count,"a").end(xlup).row))
c.value="0" & c
next c
--
Don Guillett
SalesAid Software

"Jannie" wrote in message
...
I have a column of numbers 005445688996
005675556543 and so on.

About 500 in all. I want to add a zero to the beginning of all the
numbers.
So example the first one reads: 0005445688996 and so on down the entire
column.
Please help.
Jannie