Data Entry problem
 

When I enter numbers into spreadsheets they get changed to two decimal points
(e.g. 250 = 2.5). I know there must be some global setting, but I don't know
where. Can anyone help?

Data Entry problem
 

Hi Bob

Just had somebody here today with the same problem, had me stumped.

Turns out goto: Tools Options Edit (Tab) then untick the box
marked "fixed decimal places"

Regards
Shaun


--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile: http://www.excelforum.com/member.php...o&userid=18610
View this thread: http://www.excelforum.com/showthread...hreadid=483731