OK sorry but I'm now really confused.

I need upto 1000 to be in one cell, everything over in another. the
way itis not if I enter 2210, 2000 is going to one cell and the the
210, I need 1000 and 1210.

Felix


--
nyrfan
------------------------------------------------------------------------
nyrfan's Profile: http://www.excelforum.com/member.php...o&userid=31192
View this thread: http://www.excelforum.com/showthread...hreadid=508606