Change the base

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi (from a guy in the UK)

I want to input data of a weight in lb into a cell and then use the data so
that it converts it to stones and lb.

For instance if i put in 100lb the other cell will say 7s2lb. (100/14=7
remainder2). 14lb in a stone.

How can i do this?
 
Yeah i spotted that thanks.

Now for the next question based on this same theme. If i want to graph the
results i cannot see the data as a number and therefore it won't graph. Is
there a solution?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting cell to show body weights 8
how can i use imperial units eg stones and pounds 2
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4
A few problems involving LOOKUP and SUMPRODUCT... 1
How to format in stones & pounds and then present on chart 2
how do i use excel to calculate weight (as in stone and lbs)? 6
How do i format a number into stones, pounds and ounces, please? 5
Pricing decreases as quantity increases- how to do that 2

Back
Top