Thanks:  0
Likes:  0

1. Need formula to convert meters to feet and inches instead of meters to feet and tenths.
Thanks
Jay

2. Here's one way that requires the Analysis ToolPak add-in.

=TRUNC(CONVERT(A1,"m","ft"))&"' "&ROUND(CONVERT(MOD(CONVERT(A1,"m","ft"),1),"ft","in"),0) &""""

CONVERT is handy if you don't know the conversion factors or if you want to specify your units of measure in a worksheet cell and modify them as needed.

[ This Message was edited by: Mark W. on 2002-03-07 10:39 ]

3. Here's a way to do it. I'm sure you can adapt this to your application.

1 meters
39.3701 conversion factor
39.3701 total inches
3.3701 inches
3 feet

4. Here's a way to do it. I'm sure you can adapt this to your application.

A B
1 1 meters
2 39.3701 conversion factor
3 39.3701 total inches =(A1*A2)
4 3.3701 inches =(MOD(A3,12)
5 3 feet =TRUNC(INT(A3)/12)

[ This Message was edited by: Dave Gibson on 2002-03-07 10:00 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•