📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel help

Hi

I'm creating (or trying to) a spreadsheet to record weight loss and wondered if there's any way for excel to recognise a number as stones and lbs or am I going to have to use just lbs?

Thanks

Comments

  • I don't think excel knows how to handle stones and pounds.

    What do you want to use the numbers for? If it is just recording, could you put the number of pounds in column A and the remaining pounds in the B column?

    If you want to convert to pounds you just go to column C and type:
    =(A1*14)+(B1) and hit enter.

    (14 pounds in 1 stone right? I work in kg so sorry if I'm wrong!)
  • It will be easier for you to just use lbs. If you have your weight, in pounds, in cell A1 then this formula in cell B1 would show you your weight in stone:

    =INT(A1/14) &"st" & MOD(A1,14) & "lbs"

    You can then just copy and paste the formula down the column for each weight entry
    There's no sense crying over every mistake.
    You just keep on trying till you run out of cake.
  • xbrenx
    xbrenx Posts: 962
    Part of the Furniture 500 Posts
    Forumite
    I don't think excel knows how to handle stones and pounds.

    What do you want to use the numbers for? If it is just recording, could you put the number of pounds in column A and the remaining pounds in the B column?

    If you want to convert to pounds you just go to column C and type:
    =(A1*14)+(B1) and hit enter.

    (14 pounds in 1 stone right? I work in kg so sorry if I'm wrong!)
    That sounds like a plan, scales show stones and pounds so I was trying to simplify it for myself, I will play about with that formula, thanks.
  • Sorry stones in column A and pounds in column B!
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.