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

Best Black Friday Deals 2017

Black Friday Deals for Designers & Artists: Adobe, Apple, Corel Painter, Microsoft Surface, Wacom &e…

Best Black Friday Apple Deals 2017

Black Friday 2017 : date, sites participants & bonnes affaires