Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers and Fractions in Excel
How can I display a cell with the number 2.5 as 2 lbs 8 ounces?
Thanks Alfredo Livas |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers and Fractions in Excel
=INT(A1)&" lbs "&16*MOD(A1,1)&" ounces"
-- David Biddulph "monarcabak" wrote in message ... How can I display a cell with the number 2.5 as 2 lbs 8 ounces? Thanks Alfredo Livas |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers and Fractions in Excel
Hi Alfredo,
AFAIK, about the nearest you can get with cell formatting alone is 2 8/16lbs, which you can achieve with a custom number format like: # ?/16lb\s If a formula in an adjoining cell would do, you could use something like: =INT(A1)&"lbs "&MOD(A1,1)*16&"oz." Notice I've used 'oz.' rather than 'ounce' for 1 oz., or 'ounces' for 2 or more oz. - easier to code. Cheers -- macropod [MVP - Microsoft Word] "monarcabak" wrote in message ... How can I display a cell with the number 2.5 as 2 lbs 8 ounces? Thanks Alfredo Livas |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Numbers and Fractions in Excel
Thank you!!
"David Biddulph" wrote: =INT(A1)&" lbs "&16*MOD(A1,1)&" ounces" -- David Biddulph "monarcabak" wrote in message ... How can I display a cell with the number 2.5 as 2 lbs 8 ounces? Thanks Alfredo Livas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I have excel convert fractions to decimals? | Excel Worksheet Functions | |||
Excel 2003 - Simple IF() Formula Will Not Work For Me | Excel Worksheet Functions | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Why if I type in 51570.6213 Excel converts it to 51570.5213999999 | Excel Discussion (Misc queries) | |||
Is this a known excel error?? Sequential drag down & IF ERRORS?? | Excel Worksheet Functions |