sussed it, i needed to format as custom and input 5 "0's" in to the type
box. this defaults the cell to 5 characters, anything shorter i.e. 4
becomes preceeded with 0.

thanks anyway.


--
Johno313
------------------------------------------------------------------------
Johno313's Profile: http://www.excelforum.com/member.php...o&userid=35587
View this thread: http://www.excelforum.com/showthread...hreadid=553530