Without knowing the details, it's hard to say if this is a good option
but a format of general"00000" will display a handful of 0's to th
right of whatever is in the cell without changing the value stored i
the cell

--
MrShort
-----------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...fo&userid=2218
View this thread: http://www.excelforum.com/showthread.php?threadid=49944