| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display lbs and ozs
i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear.
how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
How about trying, the format:
0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
that helps a lot, thanks you
"FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
i input my weights, in grams, in one column and convert them to lbs/ozs in
the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
Sorry I thought you were inserting data manually. How about trying a formula
like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
Hi
Suggest to use the CONVERT() function =CONVERT(400,"g","ozm") If it returns the #NAME? error then from menu ToolsAddIns check 'Analysis ToolPak add-in'...and then try If this post helps click Yes --------------- Jacob Skaria "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
thanks but could you change the formula so i can convert grams to lbs/ozs ?
"Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
Well in case of change in measurement systems you could use:
=CONVERT(A1,"g","ozm") as per Jacob. -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: thanks but could you change the formula so i can convert grams to lbs/ozs ? "Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
thanks. how do i get only 1 decimal places for the ozs, ex. 10 lbs 2.4 oz
instead of 2.4395... "Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
ROUND(...,1) or TEXT(...,"0.0")
-- David Biddulph "Trail Dog" wrote in message ... thanks. how do i get only 1 decimal places for the ozs, ex. 10 lbs 2.4 oz instead of 2.4395... "Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
=ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-TEXT(ROUNDDOWN(A1/16,0))*16,"0.0")&"
oz." -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: thanks. how do i get only 1 decimal places for the ozs, ex. 10 lbs 2.4 oz instead of 2.4395... "Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display lbs and ozs
can't get the formula to work. also, can i still total a column, does text
affect it ? "Faraz A. Qureshi" wrote: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-TEXT(ROUNDDOWN(A1/16,0))*16,"0.0")&" oz." -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: thanks. how do i get only 1 decimal places for the ozs, ex. 10 lbs 2.4 oz instead of 2.4395... "Faraz A. Qureshi" wrote: Sorry I thought you were inserting data manually. How about trying a formula like: =ROUNDDOWN(A1/16,0)&" lbs. & "&((A1/16)-ROUNDDOWN(A1/16,0))*16&" oz." So as to convert 172 (oz) in cell A1, to "10 lbs. & 12 oz."? -- Do check "Yes" if this post is helpful, Best Regards, Faraz "Trail Dog" wrote: i input my weights, in grams, in one column and convert them to lbs/ozs in the next column. when i input 400 ( grams ), it gives me 8.8 ozs instead of 14.11 ozs. ( the correct conversion ). help and thanks "Trail Dog" wrote: that helps a lot, thanks you "FARAZ QURESHI" wrote: How about trying, the format: 0 "lbs". 0 "ozs" "Trail Dog" wrote: i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear. how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| some cells display formulas, some display values | Excel Discussion (Misc queries) | |||
| How to display remaining txt file which overflowed MsgBox display? | Excel Discussion (Misc queries) | |||
| Display every 3rd category name but still display latest month | Charts and Charting in Excel | |||
| Can I display an Excel chart as my screensaver display? | Charts and Charting in Excel | |||
| Numbers display as decimal, i.e. enter 123 display 1.23 | Setting up and Configuration of Excel | |||
![Trail Dog[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
