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
|