Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fractions in formulas
I created a custom number format (# ?/3) that seems to work just fine in all
worksheets except one particular formula. All number and formula use this formatting. The following formula displays the numerical vaues in decimal notation instead of the custom fraction formatting of the cell? Does it have anything to do with the displaying of text within the same cell? Can I get around it? IF('Institution Entry'!L160,IF(F153="","Adjustment for Dev Hours = "&F143&" ERN Hrs - "&H143&" DEV Hrs = "&(F143-H143)&" SEM Hrs","Adjustment for Dev Hours = "&F153&" ERN Hrs - "&H153&" DEV Hrs = "&(F153-H153)&" SEM Hrs"),"") This is a typical result the result of the formula. Adjustment for Dev Hours = 2.66666666666667 ERN Hrs - 2.66666666666667 DEV Hrs = 0 SEM Hrs In this example, cells F143 and H143 both display 2 2/3. So why does the formula convert to decimal? I hope this is enough information to help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fractions in formulas
Not sure but experiment with something like =TEXT(B5,"# ?/?")&" sem hrs"
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "JWH23" wrote in message ... I created a custom number format (# ?/3) that seems to work just fine in all worksheets except one particular formula. All number and formula use this formatting. The following formula displays the numerical vaues in decimal notation instead of the custom fraction formatting of the cell? Does it have anything to do with the displaying of text within the same cell? Can I get around it? IF('Institution Entry'!L160,IF(F153="","Adjustment for Dev Hours = "&F143&" ERN Hrs - "&H143&" DEV Hrs = "&(F143-H143)&" SEM Hrs","Adjustment for Dev Hours = "&F153&" ERN Hrs - "&H153&" DEV Hrs = "&(F153-H153)&" SEM Hrs"),"") This is a typical result the result of the formula. Adjustment for Dev Hours = 2.66666666666667 ERN Hrs - 2.66666666666667 DEV Hrs = 0 SEM Hrs In this example, cells F143 and H143 both display 2 2/3. So why does the formula convert to decimal? I hope this is enough information to help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fractions | Excel Worksheet Functions | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) | |||
Fractions | Excel Discussion (Misc queries) |