Or, you can just custom format as 00000

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jem" wrote in message
...
hi to all,

I have this data 1234 in cell K27.
how to make macro that will add "0 to the beginning:

My data is:

1234

That the result will look like this:

"01234



Thanks,
Lorena