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.
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 phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.