Can Excel work with imperial units ? (Standard, not using VBA)
If yes how can I enter 1'-5 3/4" in a cell? (not using decimal feet)
Can I set a cell to display a numeric value in Decimal/Engineering/Architectural ? (imperial working units)
Thanks
Can Excel work with imperial units ? (Standard, not using VBA)
If yes how can I enter 1'-5 3/4" in a cell? (not using decimal feet)
Can I set a cell to display a numeric value in Decimal/Engineering/Architectural ? (imperial working units)
Thanks
Assuming you always use the same format
=LEFT(D3,FIND("'",D3)-1)*12+VALUE(LEFT((RIGHT(D3,LEN(D3)-FIND("-",D3))),LEN(RIGHT(D3,LEN(D3)-FIND("-",D3)))-1))
will convert 1'-5 3/4" int 17.75
=QUOTIENT(F3,12)&"'-"&TEXT(F3-(QUOTIENT(F3,12)*12),"# 0/0") & CHAR(34)
will do the reverse
note it uses ' to figure out where the feet are and - to figure out where the inches start and assumes it ends in " so make sure they are included or you will get an error
Excel can display in various formats
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Hi,
don't know if this is of help, but if for some reason you decide to enter a fraction in a cell without quote or double quote (or some other non numeric character) XL will think it's a date.
To avoid this enter 0 then a space, then your fraction
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks