hi,

I've just had the same problem, are you using 2003 if so allow the eror
check to work you will have the little green triangle in top left of the
cell. The error indicator will allow you to change from Text to number,
there is an option there.

to activate error check, tools, options, error checking and tick box in
settings.

hope this helps


--
Clash
------------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
View this thread: http://www.excelforum.com/showthread...hreadid=507118