Hi TechGuyatwork

Format the cells like this

Select them
Ctrl-1
Custom, use 00000000

--
Regards Ron de Bruin
http://www.rondebruin.nl


"TechGuyatwork" wrote in message
...
Ok I have data in excel that looks like this:

2345
23667867
12345678
8564
3557
The data needs to be formatted to look like this
00002345
23667867
12345678
00008564
00003557
How do I add the zero to eacfh of the fields?
Does this entail scripting of some sort?
Please reply!!! ASAP!!!