If your stock numbers always have the same format xx-xxxx like your
example, then creating a ##-#### format is a better way to solve your
problem. Set that format to the whole column. That way when the user
enters 102005, Excel will format it in 10-2005. Saves you two key
strokes (' and -) for each entry :)

Alain


--
mcs51mc
------------------------------------------------------------------------
mcs51mc's Profile: http://www.excelforum.com/member.php...o&userid=28645
View this thread: http://www.excelforum.com/showthread...hreadid=483389