Report

How to convert ounces (oz) to milliliter

Ask a question JPortillo 1Posts Sunday May 14, 2017Registration date May 14, 2017 Last seen - Last answered on May 15, 2017 at 12:07 AM by vcoolio
Good morning to all, can someone please tell me how to convert ounces (oz) to milliliter s (ml). Thanks
See more 
Helpful
+0
plus moins
Hello JPortillo,

I assume that your are wanting to do the conversions in Excel.

If you have, for example, your fluid ounce(US?) values in Column A starting at A2, in B2 type the following formula:-

=CONVERT(A2,"oz","l")*1000

and then drag it down as far as you need.

You'll notice that, once you type in this part of the formula:-

=CONVERT(A2,

a dropdown will appear with various abbreviated measurement choices from which you can select. You will find "oz" for fluid ounces(US) but you won't find one for millilitres. So, the conversion needs to be done to litres first and then multiplied by 1000 (1000ml to 1lt.) to obtain the result. Hence, this part of the formula:-

*1000

The "oz" is the abbreviation for ounces(US) and "l" is the abbreviation for litres.

You can, of course, just Google your query and a conversion chart will be immediately presented for you to use.

I hope that this helps.

Cheerio,
vcoolio.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!