You are here: HomeExcelTutorials

# feet and inches to meters

## feet and inches to meters

Price: FREE

what formula will allow me to convert feet and inches to meters. current format of cell is 5\$ 05.00\$

Visit publisher's web-site: feet and inches to meters

Category and Tags: ExcelTutorials :

## Related Tutorials

### convert meters to feet/inches

Free: Yes
Tags: Excel ›

I'm trying to convert from meters to feet and inches (not just feet or not just inches).
so if I have 2 meters, I want the result to read 6 feet, 2 inches for example not 6.x feet or 78 inches.
here's the formula I have, which I can't get right.
=CONVERT(2,"m","ft""in").

### Convert Feet & Inches to Metres

Free: Yes
Tags: Excel ›

I'd like to find a way of converting feet and inches (expressed as, for example = 12'4") to meters (m). I won't be using any imperial fractions.
I've had a play with the convert function which manages to do one or the other (eg feet to meters, inches to meters) but not both together. Of course I'm sure it does but my excel knowledge is woeful.

### Convert feet and inches to meters

Free: Yes
Tags: Excel ›

I have used the following formula to convert to inches,
=LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3)),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3))-1))
But when I divide it by the conversion factor inches to meters I get errors
=(LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3)),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3))-1))/0.0254

### Convert feet and inches to decimal feet

Free: Yes
Tags: Excel ›

I am working in excel 2003 and I need to convert feet and inches into decimal feet.
Example: 15'-10 5/8" to 15.88542
15'-10 5/8" will be in say, column B, and the conversion will be in say, column Q.
This formula will be copied all the way down the page.
Any thoughts on how to do this or can it even be done in this version?

### Is it possible to display feet and inches in one cell ?

Free: Yes
Tags: Excel ›

Microsoft Excel 2007 - I am trying to convert a number to feet and inches. As far as I can tell it will only show feet or inches but not both such as

## Related Applications & Scripts

### Length measurement converter

Free: Yes
Tags: JavaScript › Excel Converters

JavaScript can help you find length equivalents. This script can convert to and from Centimeters, Inches, Feet, Yards, Meters, Chains, Kilometers, Miles.

### Veqa Image Resizer

Free: No
Tags: PHP › Excel Image Manipulation

Veqa Image Resizer is a PHP tool to resize Web images on the fly. Features 82 size presets, width/height dimensions, constrain proportions, pixels, percentage, inches, centimeters, millimeters, points, picas, adding, subtracting, multiplying, dividing, randomizing, limiting, and multiple resizing. Supports JPG, GIF (and animations), PNG, BMP; and GD, ImageMagick, MagickWand. Also provides interface, login protection, caching, cache gallery, file saving, class functions, reformatting, user documentation, and more. Resize all your images and resize your time by getting it all on the dynamic fly.
Features:
Get resized images on the fly, save files on Web server, and class functions to use in your own scripts. Supports JPG, GIF (and animations), PNG, and BMP image formats. Supports GD, ImageMagick, and ImageMagick MagickWand for PHP. Provides an interface for easier use, which also comes with login protection. Cache images for on-the-fly along with its very own cache gallery.