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.

Sony Vaio Z Canvas release date, price and specs: Another Surface Pro rival but for the US

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

Steve Albini's notorious email is now a punchy music video

Live Photo tips: How to take Live Photos on the iPhone 6s, how to view, share, edit and find Live…