MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Scott on August 21, 2001 9:49 AM

I'm working with a large chart of numbers, and I need to display them as fractions (1/16ths, 1/8ths, 1/4, 1/2).

I've formatted my cells to display as 16ths. The problem is that 1/4 is displayed as 4/16ths.

Please e-mail me with help.



Posted by Mark W. on August 21, 2001 9:50 AM

Don't use # ??/16 as your format. Use # ??/?? instead.