Weight display (LB & OZ)

  • Thread starter Thread starter Blueyonder
  • Start date Start date
B

Blueyonder

Hi,
Hope somone can help.
I am looking for a way of displaying weight (LB & OZ) but have so far been
unable to find anything.
I am currently using this method to display 9LB and 5OZ
9 5/16
I would ideally like it to read 9.5 but as i said I have had no luck in
finding a way.

Thanks in advance for your help.

Andrew
 
What you are asking for would seem to be impossible. How would 9 lbs 10 oz
be displayed? How would we know that 9.1 and 9.10 are not the same? If the
cell A1 displays 9.5 and B1 has =2*A1 how is Excel to know the answer is
18.10.

You could have a 'helper' column for people who do not understand fractions.
For example if A20 displays 9 5/16 and B20 has =INT(A20)&"lbs
"&(A20-INT(A20))*16&"oz" it will display 9lbs 5oz.

Best wishes
Bernard
 
Enter it as 9.05 and use custom format 0"lb ".00"oz"
to convert it to 9 5/16 use

=DOLLARDE(A1,16)

go metric and you won't have to worry about these primitive measurments <g>

note that DOLLARDE is part of the ATP that comes with Excel but might not be
installed,
do tools>add-ins and check it if it isn't
 
go metric and you won't have to worry about these primitive measurments <g>

LOL !

Thanks to both above replies


Andrew
 
Back
Top