FormatCellsCustom, and enter a value of 00000

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Jenilise" wrote in message
...
I have a spreadsheet with over 1000 CSI codes that are only 4 numbers. The
4
numbered CSI codes all need a Zero in front to make it a five digit code.
Is
there an easy way to just globally add a zero to just these 4 digit codes?
Example:
Wrong codes How I want them to look
2515 02515
2351 02351
7524 07524

Just hoping there is a way to avoid having to go into each cell and add a
zero.
Thanks for your help