Well, if you had the 10.3333' in cell A1, you could put this formula in A2:
=CONCATENATE(INT(VALUE(IF(RIGHT(A1,1)="'",LEFT(A1, LEN(A1)-1),A1))),"'
",ROUND(((VALUE(IF(RIGHT(A1,1)="'",LEFT(A1,LEN (A1)-1),A1))-INT(VALUE(IF(RIGHT(A1,1)="'",LEFT(A1,LEN(A1)-1),A1))))*12),0),"""")

If you could lose the "'" at the end of 10.3333 then the formula would only
need to be: =CONCATENATE(INT(A1),"' ",ROUND((A1-INT(A1))*12,0),"""")

This is someone else's technique, and I apologize for not being able to
properly attribute credit to them by coming up with their name, but I am
blanking right now - it's either John Walkenbach or Joseph Rubin.

Good Luck,

Tom Hayakawa



"rebar" wrote:

IS there a macro or formula to enter 10.333' as 10'-4" or 10-04.