Formatting cells...

  • Thread starter Thread starter barrowfordred
  • Start date Start date
B

barrowfordred

How do I format a cell so that the data is expressed as stones an
pounds ie weight????:confused
 
barrowfordred > said:
How do I format a cell so that the data is expressed as stones and
pounds ie weight????:confused:
Click to expand...

You don't! Date and time are the only built-in 'multiple unit' formats in
Excel. You would need to enter data as just pounds, or in two different
cells (one for stones, the other for pounds).
 
You must log in or register to reply here.

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

Imperial Weights in Excel 1
How do I format a cell to show weight in stones and pounds? 2
Need help with Line Chart... 5
Formatting for Weights pounds & ounces 2
calculate shipping costs in excel 2007 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
format for weight 4

Back
Top