decimal point problem in excel

  jonnyg111 14:49 03 Jun 07

I am being driven crazy by this! If I type 450 into a cell, it displays as 4.5 - every integer number is automatically divided by 100. At the moment I get round this by typing 450.0, and then I get 450 okay. But how do I fix this properly please?


  FreeCell 16:18 03 Jun 07

Sounds like the cell(s) have been formatted as Number with decimal places set to two.

Right click the offending cell, select Format Sell and then set to "general" or to Number with zero decimal places.

  VoG II 17:56 03 Jun 07

Tools > Options > Edit tab > untick 'Fixed decimal places'.

  jonnyg111 19:11 04 Jun 07

Thank you, that's brilliant, fixed.

  Chris T 08:39 10 Jun 07

Could someone please tell mewherethe activex button is and how do I disable it?

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009