A Alanness Feb 24, 2004 #1 If I type in an integer value into a cell it gets divided by 1000. What do I do ?
B Bob Phillips Feb 24, 2004 #2 Alannes, Sounds like the fixed decimal places is set. Go into Tools>Options>Edit, and see if the Fixed Decimal check box is checked. If so, uncheck it. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Alannes, Sounds like the fixed decimal places is set. Go into Tools>Options>Edit, and see if the Fixed Decimal check box is checked. If so, uncheck it. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
A A.W.J. Ales Feb 24, 2004 #3 Alanness, Uncheck the option Fixed : Tools / Options / Tab Edit / Fixed Decimal Places -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails *
Alanness, Uncheck the option Fixed : Tools / Options / Tab Edit / Fixed Decimal Places -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails *
