If it is always 4 digits, how about adding 9000? I mean, put 9000
somewhere in the cell then copy it and paste special with operation
add.
mas


--
mas_detokyo


------------------------------------------------------------------------
mas_detokyo's Profile: http://www.excelforum.com/member.php...o&userid=26712
View this thread: http://www.excelforum.com/showthread...hreadid=401441