Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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
xbrenx
Posts: 962
Forumite
in Techie Stuff
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
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
0
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!)0 -
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 entryThere's no sense crying over every mistake.
You just keep on trying till you run out of cake.0 -
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.The_Grandmaster wrote: »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!)0 -
Sorry stones in column A and pounds in column B!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
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