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

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

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

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

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

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

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

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

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

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

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

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