| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert decimals into mm in excel spreadsheet
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert decimals into mm in excel spreadsheet
"Noddyhawk" wrote:
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Convert decimals into mm in excel spreadsheet
CONVERT is a ATP function, If the CONVERT function is not available, install
and load the Analysis ToolPak add-in ...(ToolsAddins) =CONVERT(3/4,"in","mm") If this post helps click Yes --------------- Jacob Skaria "Noddyhawk" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have excel convert fractions to decimals? | Excel Worksheet Functions | |||
| convert fractions to decimals | Excel Worksheet Functions | |||
| How do I convert 4'6" into decimals? | Excel Worksheet Functions | |||
| Bond prices convert to decimals | Excel Discussion (Misc queries) | |||
| Convert $ amount from excel to access? No decimals but 00 at end | Excel Worksheet Functions | |||
Linear Mode
