A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

format for weight



 
 
Thread Tools Display Modes
  #1  
Old February 17th, 2010, 01:53 AM posted to microsoft.public.excel.newusers
exntluser
external usenet poster
 
Posts: 4
Default format for weight

In Excel 2007 is it possible to format cells for weight, such as stones &
lbs?
e.g. 14 lbs = 1 stone


  #2  
Old February 17th, 2010, 03:19 AM posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
 
Posts: 516
Default format for weight

You could use custom format # ??/14
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"exntluser" wrote in message
...
In Excel 2007 is it possible to format cells for weight, such as stones &
lbs?
e.g. 14 lbs = 1 stone

  #3  
Old February 17th, 2010, 10:14 AM posted to microsoft.public.excel.newusers
exntluser
external usenet poster
 
Posts: 4
Default format for weight


"Bernard Liengme" wrote in message
...
You could use custom format # ??/14
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"exntluser" wrote in message
...
In Excel 2007 is it possible to format cells for weight, such as stones &
lbs?
e.g. 14 lbs = 1 stone

Please excuse my lack of knowledge on this subject, but how would I go about
using custom format # ??/14 ?


  #4  
Old February 17th, 2010, 02:44 PM posted to microsoft.public.excel.newusers
Bernard Liengme
external usenet poster
 
Posts: 516
Default format for weight

Let's assume you are using Excel2003 (or earlier)
Select the cells to be formatted
On the Menu use Format | Format Cells and click "Custom" on left side of
dialog
In Custom dialog, locate the Type box and type in the # ??/14

More info at http://office.microsoft.com/en-ca/ex...995001033.aspx
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"exntluser" wrote in message
...

"Bernard Liengme" wrote in message
...
You could use custom format # ??/14
The you would type, for example 12 2/14 for 12 stone 2 lbs
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"exntluser" wrote in message
...
In Excel 2007 is it possible to format cells for weight, such as stones
& lbs?
e.g. 14 lbs = 1 stone

Please excuse my lack of knowledge on this subject, but how would I go
about using custom format # ??/14 ?

  #5  
Old February 17th, 2010, 06:44 PM posted to microsoft.public.excel.newusers
Gord Dibben
external usenet poster
 
Posts: 20,252
Default format for weight

Not a format.............needs a helper cell.

=INT(A3/14)&" Stones "&ROUND((A3/14-INT(A3/14))*14,0)&" lbs"


Gord Dibben MS Excel MVP


On Wed, 17 Feb 2010 00:53:59 -0000, "exntluser" wrote:

In Excel 2007 is it possible to format cells for weight, such as stones &
lbs?
e.g. 14 lbs = 1 stone


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.