Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 577
Default feet and inches to meters

what formula will allow me to convert feet and inches to meters. current
format of cell is 505.00
--
Thanks in advance
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default feet and inches to meters

=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
--
David Biddulph


"scott" wrote in message
...
what formula will allow me to convert feet and inches to meters. current
format of cell is 5'05.00"
--
Thanks in advance



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 293
Default feet and inches to meters

Hi Scott,

Assuming the actual number is 505 and it's just a custom format you're using to display it as 505.00, you could use a formula
like:
=(INT(A1/100)*12+MOD(A1,100))*0.0254

--
Cheers
macropod
[Microsoft MVP - Word]


"scott" wrote in message ...
what formula will allow me to convert feet and inches to meters. current
format of cell is 505.00
--
Thanks in advance


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 577
Default feet and inches to meters

thank you very much
--
Thanks in advance


"David Biddulph" wrote:

=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
--
David Biddulph


"scott" wrote in message
...
what formula will allow me to convert feet and inches to meters. current
format of cell is 5'05.00"
--
Thanks in advance



.

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default feet and inches to meters

You're welcome. Glad it did the job.
--
David Biddulph


"scott" wrote in message
...
thank you very much
--
Thanks in advance


"David Biddulph" wrote:

=CONVERT(LEFT(A1,FIND("'",A1)-1)*12+MID(A1,FIND("'",A1)+1,LEN(A1)-FIND("'",A1)-1),"in","m")
--
David Biddulph


"scott" wrote in message
...
what formula will allow me to convert feet and inches to meters.
current
format of cell is 5'05.00"
--
Thanks in advance



.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert meters to feet/inches Ann Excel Worksheet Functions 30 April 5th 23 01:21 PM
Convert inches & display as Feet Inches and Fractions -- BUG FREE Mark Main Excel Worksheet Functions 12 November 26th 08 09:50 PM
Converting from feet, inches and fractions to inches and decimal p Dee Setting up and Configuration of Excel 5 September 18th 07 04:18 PM
Feet, inches and fractions to inches and dec.....reposting for Pet Dee Setting up and Configuration of Excel 1 September 18th 07 04:02 PM
How do I convert Meters to Feet and Inches? Dave S Excel Worksheet Functions 7 December 16th 05 12:33 PM


All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"