Excel feet and inches to millimeters

0 votes

I have many excel field witch contains ft and inches example: 5' 10".

How to i convert it to meters assuming the feet and inches value is on A1.

iv tried to backtrack this formula with no success

=INT(CONVERT(A1,"mm","ft")) & " '" &  12*(CONVERT(A1,"mm","ft")-INT(CONVERT(A1,"mm","f
Feb 22, 2022 in Database by Edureka
• 13,630 points
752 views

1 answer to this question.

0 votes

There are certain direct formulas to convert inches to millimeters in excel 

You'll have to use it directly in Excel 

for converting inches to millimeter  -  =CONVERT(A2,"in","mm")
for converting inches to centimeter -  =CONVERT(A2,"in","cm")


And in excel sheet  u can find an option KUTOOL>CONTENT>UNIT conversion option 
thereafter selecting unit conversion, select the unit category from Units drop-down list, and specify the units you want to convert between two lists if you want to display the result in a comment, check to Add results as a comment
select ok and now you can see the converted values

answered Feb 23, 2022 by gaurav
• 22,970 points

Related Questions In Database

0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24, 2022 in Database by Edureka
• 13,630 points
1,078 views
0 votes
1 answer

How to read and write excel file

When broken down into steps, reading an ...READ MORE

answered Mar 25, 2022 in Database by Edureka
• 13,630 points
183 views
0 votes
1 answer

How to read and write excel file

When broken down into steps, reading an ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 22,970 points
181 views
0 votes
1 answer

EXCEL How to check if Column A contains specific value and Column B contains 2 specific values?

If you're looking for the string CHECK in cells ...READ MORE

answered Apr 6, 2022 in Database by gaurav
• 22,970 points
195 views
0 votes
1 answer

Find the serial number with criteria

Use the filter function: =FILTER($C$11:$C$39;($H$11:$H$39=MAXIFS($H$11:$H$39;$N$11:$N$39;4))*($N$11:$N$39=4)) Maybe you have to ...READ MORE

answered Jan 10 in Others by narikkadan
• 59,740 points
104 views
0 votes
1 answer

Excel Vlookup function to map duplicate and get the max occurence value

Assuming there is no Excel version restriction ...READ MORE

answered Feb 4 in Others by narikkadan
• 59,740 points
80 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
8,815 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
270 views
0 votes
1 answer
0 votes
1 answer

Excel formula to remove comma, spaces, period and add a text

The steps to accomplish this are as ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 22,970 points
1,075 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP