excel 2007 auto correct

  staples printer cartridge 18:48 11 Sep 2011
Locked

How do I stop Excel auto correcting my fractions in a cell? So I enter 10/30 and it comes up with 1/3. I want it to stay as 10/30. Thanks Tom

  mgmcc 19:11 11 Sep 2011

As long as you don't want it to calculate as 1/3, enter it preceded with an apostrophe. It will then be a text string instead of a number:

'10/30

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?