Cell formatting in excel

  • Thread starter Thread starter Odyssey 62
  • Start date Start date
Hi,

I'm not sure about a format but with a number of pounds in A1 try this.

=INT(A1*0.0714286)&" St " &INT((A1*0.0714286-INT(A1*0.0714286))/0.0714286)&"
lbs"

It will start losing accuracy at around 2500000 pounds.

Mike
 
David,

When I saw your answer i couldn't believe I'd made such a simple thing so
complicated. Thanks.

Mike
 

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

Change the base 3
Formatting cell to show body weights 8
How to show data between two dates? 3
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4
How do i format a number into stones, pounds and ounces, please? 5
Pricing decreases as quantity increases- how to do that 2
A few problems involving LOOKUP and SUMPRODUCT... 1
Custom Number Format 6

Back
Top