Forum Discussion

Jason_Bradbury's avatar
Jason_Bradbury
Copper Contributor
Dec 28, 2022

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 cell in a table in the format of 15lb8oz but I can't work out how to do this and excel be able to recognize this and use it for calculations.

I would appreciate any input, I've spent hours trying to find out how I could achieve this.

 

Kind regards

 

Jason

excel
  • WelberMohamad's avatar
    WelberMohamad
    Copper Contributor
    Dec 28, 2022
    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.
    • Jason_Bradbury's avatar
      Jason_Bradbury
      Copper Contributor
      Dec 28, 2022
      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

Resources