If I type a number into a cell it appears as 0.010.02 etc How do i get it to appear as 1,2 I have tried numbers and general to no advantage.All help gratefully received.
Which version? The cell is set to contain binary numbers. You must change it to decimal.
Tools > Options > Calculation tab > untick 'Automatically insert a decimal point' (or similar wording - that is for Excel 2007).
I think it might be 'Use a fixed number of decimals' in earlier versions.
Iam using Office Home and Students Edition 2007But I cannot find Tools could you help Please?Thank You.
Click the Office button (top left) and select Excel Options.Click on Advanced.Untick 'Automatically insert a decimal point'(the second tick box down).Click OK.
Thank you "Vog" once again you have come up Trumps
This thread is now locked and can not be replied to.
OnePlus 5 review
See the work of famous artists playing with toys
iPad Pro 10.5in (2017) review
Comment faire une capture d’écran sur un Mac ?
© Copyright 2017 IDG UK. All Rights Reserved.