Number in cell appears to be 10000 times too small
 

Whenever I type a number into a cell, it divides it self by 10,000. I can
enter the number as text and it works. No amount of formatting has solved the
problem. What is wrong?

Kind Regards

Number in cell appears to be 10000 times too small
 

at the top menu

goto tools=options==edit
uncheck fixed decimal


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539584