Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limited fraction cell format
Hi, I would like to format cells to show a decimal as a fraction. However I want the fraction to be only selected ones. Ex: if the decimal is 4.6719 I want to show 4 11/16 NOT 4 43/64. I want the fractions to round up to the nearest 16th, 8th, 4th or half. Is there a way to do this? Thanks, Lisa -- vencopbrass ------------------------------------------------------------------------ vencopbrass's Profile: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516876 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |