Million fractions!

[Mark DW]

Hello,

Help! For some reason whenever I type a number in a cell it scales i
down by a factor of a million! e.g if I type in 3, when I click awa
from that cell it turns it into 0.000003. I must have accidentall
changed some setting but I'm at aloss to discover what!

Please excuse my naivety, I'm not too hot with Excel!

Thanks

MD

 

[RagDyer]

<Tools> <Options> <Edit> tab,
And then *uncheck* "Fixed Decimal Places".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hello,

Help! For some reason whenever I type a number in a cell it scales it
down by a factor of a million! e.g if I type in 3, when I click away
from that cell it turns it into 0.000003. I must have accidentally
changed some setting but I'm at aloss to discover what!

Please excuse my naivety, I'm not too hot with Excel!

Thanks

MDW

 

[Ron Rosenfeld]

Hello,

Help! For some reason whenever I type a number in a cell it scales it
down by a factor of a million! e.g if I type in 3, when I click away
from that cell it turns it into 0.000003. I must have accidentally
changed some setting but I'm at aloss to discover what!

Please excuse my naivety, I'm not too hot with Excel!

Thanks

MDW

Tools/Options/Edit and see DEselect "Fixed Decimals". If that's not it, post
back.


--ron

 

[Mark DW]

Dear Ron and Rd,

Thank you, thank you, thank you!

My nightmare is over...

Best wishes

MD