Archive for April, 2009

Playing with Fractions and Integers in Excel
April 1, 2009

Have you faced a situation in Excel where you want it to automatically show integers as integers and fractions as proper fractions (e.g. 8/3) and not mixed fractions (e.g. 2 2/3) or decimals (e.g. 2.6667)?
Well, I faced that situation today.  Excel does not have a direct solution to this.
Yes, you can go to ‘Format Cells’ [...]