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? Jonny
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.
Tools > Options > Edit tab > untick 'Fixed decimal places'.
Thank you, that's brilliant, fixed.
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.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.