Hi TechGuyatWork

Set the custom number format to 00000000

---
Regards,
Norman



"TechGuyatwork" wrote in message
...
not all the numbers are the same.

it must be 8 numerical fields but some numbers are
well let me show you an example.

01234567
12345678
123
47864
3456763

They need to fixed up to look like:

01234567
12345678
00000123
00047864
03456763

How do I get excell 2003 to do this for me? Or does it need to be a
script
of some sort?