Use Fractions in Microsoft Excel 2007/2010?

By Moe Jame Share
Browse the Microsoft Excel 2007/2010 category for more tutorials

How to use fractions in Excel

  • Enter fraction with a zero and space preceding it, eg 1/2 as 0 1/2

 

  • Hit Enter. Entry will now show as a fraction in the cell and as a decimal above

 

Keywords

FractionsUse

More Microsoft Excel 2007/2010 Tutorials

How to Delete Blank Rows on Microsoft Excel 2007/2010

How to Keep Column Headings Visible When Scrolling on Microsoft Excel 2007/2010

How to Copy Column Width To A New Worksheet on Microsoft Excel 2007/2010

How to Print Title On Each Page Of A Document on Microsoft Excel 2007/2010

How to Copy Formatting To Multiple Cells on Microsoft Excel 2007/2010

How to Use Fractions on Microsoft Excel 2007/2010

How to Use IF Function on Microsoft Excel 2007/2010

How to Print Same Cell Range From More Than One Worksheet on Microsoft Excel 2007/2010

How to Specify Allowed Data on Microsoft Excel 2007/2010

How to Customize Error Message on Microsoft Excel 2007/2010

Follow us on Twitter Subscribe to our Feeds Become a Fan on Facebook

Follow Us

RSS
facebook
twitter

Didn't find your answer?

Post your question on our forum and ask the community!

Ask a question!