excel 2007 auto correct

  staples printer cartridge 18:48 PM 11 Sep 11

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 PM 11 Sep 11

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:



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

Best Black Friday deals 2015 live blog: Best UK Black Friday deals & best UK Black Friday tech…

1995-2015: How technology has changed the world in 20 years

ZAK releases more videos showing what happens if you ask other professions to work for free

20 Mac Power User Tricks... That You Didn't Know