| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited fraction cell format
Lisa,
FormatCells==Fractions .... allows you to select 16th/8th etc "vencopbrass" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited fraction cell format
yes that's true but I want it to be either 1/4, or 3/8, or 5/16, etc... based on what the decimal is. This is for fabrication and I can't tell the shop to make something that is 5.7659 inches. I would tell them 5 13/16" which in decimal form is 5.8125. See? The cell would need to round up to the nearest 16th or 8th or 4th or 2nd. I don't know how to custom format cells. But using hte formats given I would have to make it either 16th or 8th etc but not all. Lisa -- vencopbrass ------------------------------------------------------------------------ vencopbrass's Profile: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516876 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited fraction cell format
=MROUND(A1,1/16)
FormatCellsNumber tabCustom In the Type box, enter: # ??/?? -- Kind regards, Niek Otten "vencopbrass" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limited fraction cell format
Thanks, so far so good. -- vencopbrass ------------------------------------------------------------------------ vencopbrass's Profile: http://www.excelforum.com/member.php...o&userid=31868 View this thread: http://www.excelforum.com/showthread...hreadid=516876 |
| Reply |
| 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) | |||
Linear Mode
