Convert decimals into mm in excel spreadsheet

N

Noddyhawk

I have a spread sheet with columns of inches shown in 3 decimals points. eg
3/4" is shown as 0.750. i wish to change these measurements into millimetres.
Can someone please give a step by step instruction guide for me?
I have tried "convert" function but cannot seem to get it to work correctly.
Thanks for your help.
Kind regards,
Noddyhawk.
 
J

JoeU2004

Noddyhawk said:
I have a spread sheet with columns of inches shown in 3 decimals points.
eg
3/4" is shown as 0.750. i wish to change these measurements into
millimetres.
Can someone please give a step by step instruction guide for me?
I have tried "convert" function but cannot seem to get it to work
correctly.

Well, I would just multiply by 25.4. But I 'spose you could also use the
CONVERT function. If A1 contains 0.75 (for example), then:

=A1 * 25.4

or

=convert(A1,"in","mm")

If you have trouble getting the format right, click on Format > Cells >
Number > Number and specify a desired number of decimal places.

If this does not solve your problem, post a specific example and explain how
the result is not what you need.
 
J

Jacob Skaria

CONVERT is a ATP function, If the CONVERT function is not available, install
and load the Analysis ToolPak add-in ...(Tools>Addins)

=CONVERT(3/4,"in","mm")

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top