Single Numbers

  Cesar 10:21 06 Jun 2009
Locked

If I type a number into a cell it appears as 0.01
0.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.

  Graham. 10:27 06 Jun 2009

Which version? The cell is set to contain binary numbers. You must change it to decimal.

  VoG II 10:52 06 Jun 2009

Tools > Options > Calculation tab > untick 'Automatically insert a decimal point' (or similar wording - that is for Excel 2007).

  VoG II 10:57 06 Jun 2009

I think it might be 'Use a fixed number of decimals' in earlier versions.

  Cesar 11:17 06 Jun 2009

Iam using Office Home and Students Edition 2007
But I cannot find Tools could you help Please?
Thank You.

  VoG II 11:20 06 Jun 2009

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.

  Cesar 11:30 06 Jun 2009

Thank you "Vog" once again you have come up Trumps

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

Elsewhere on IDG sites

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 ?