Weight display (LB & OZ)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Blueyonder - 29 Apr 2004 16:39 GMT

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

Reply to this Message

Bernard V Liengme - 29 Apr 2004 18:05 GMT

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

> Hi,
> Hope somone can help.
[quoted text clipped - 8 lines]
>
> Andrew

Reply to this Message

Peo Sjoblom - 29 Apr 2004 18:32 GMT

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

Signature

Regards,

Peo Sjoblom

> Hi,
> Hope somone can help.
[quoted text clipped - 8 lines]
>
> Andrew

Reply to this Message

Blueyonder - 30 Apr 2004 10:34 GMT

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

LOL !

Thanks to both above replies

Andrew

Reply to this Message