Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dilbert
 
Posts: n/a
Default how do i convert weight (stones+llbs) to llbs?

I wish to graph weight loss and record stones and llbs in total as llbs.

Is this achievable?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default how do i convert weight (stones+llbs) to llbs?

You could:
a) enter stones in one column (say A1) and pounds in the ext (B1) and use
=A1*14+B1 to compute pounds
or
b) format the range of cells to be used with Custom format # ??/14 and enter
scale reading in form 10 5/14 (wishful thinking?) and plot this data.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dilbert" wrote in message
...
I wish to graph weight loss and record stones and llbs in total as llbs.

Is this achievable?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONVERT Function Disappered in Excel Gord Dibben Excel Discussion (Misc queries) 3 April 13th 05 07:59 PM
Convert Numeric into Text Monty Excel Worksheet Functions 0 December 18th 04 09:25 PM
How do I use Excel's convert function for apothecary weight? S Code Excel Worksheet Functions 1 November 19th 04 07:13 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"