change feet/ inches to decimals

  • Thread starter Thread starter Roderick
  • Start date Start date
R

Roderick

I want to insert into a cell just like shown 10'-4 3/8" and have it to change
to a deciamls (10.3645) in another cell. Please help.
 
As an alternative to Chip's macro solution, here is a one-liner version that will also work...

Function ConvertFeetInches(S As Variant) As Variant
ConvertFeetInches = Evaluate(Replace(Replace(Replace(S, "'-", "+("), " ", "+"), """", ")/12"))
End Function

Rick
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How To Convert Decimal To Inches 2
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
convert decimal inches into feet and inches 4
change decimal to feet and inches 10
identifying the last figure in an cell and then format it. 2
How to format feet/inches (ft'in") 4
display feet and inches 2
decimal feet to feet-inch-sixteenths conversion 1

Back
Top