Thread: Excel to convert gramms into Ponds...

How can I convert a given weight in Gramms into pounds and ounces using an
Excel formula

Look at the CONVERT function in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ADavies" <ADavies@discussions.microsoft.com> wrote in message
news:450DB369-75B3-4572-A93A-726F5C53E9CF@microsoft.com...
> How can I convert a given weight in Gramms into pounds and ounces using an
> Excel formula

Pounds
=A1 / 453.59237

Ounces
=A1 / 28.3495231

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"ADavies" <ADavies@discussions.microsoft.com> wrote in message
news:450DB369-75B3-4572-A93A-726F5C53E9CF@microsoft.com...
> How can I convert a given weight in Gramms into pounds and ounces using an
> Excel formula