Forum Discussion
Using pounds and ounces in tables
Hi all, I am trying to create a workbook that tracks the weight of fish in a lake, the problem I have is that I want to use pounds and ounces for unit of weight. I would like to display weight in a...
Hello,
Working with conversion of weights / hours / dates can really be a bit of work when it comes to carrying out the calculations. Converting the value using =CONVERT(value,"kg","lbm") would bring the result easier to work with in excel.
Working with conversion of weights / hours / dates can really be a bit of work when it comes to carrying out the calculations. Converting the value using =CONVERT(value,"kg","lbm") would bring the result easier to work with in excel.
- Hello,
Thanks for the quick reply, I think this may work for my task.
One question I have is when the value is say 19lb0oz this conversion doesn't display the 'lbs' after the 19, for example I see '8.618' '19 oz', but if my value has ounces I see it correctly like this 7.484 16lbs 8/16oz. do you know why this might be?
Many thanks
Jason
