"rk@morsesteel" wrote:

How can I format a cell and enter "10.250" and have it converted to "10'-3""
automatically

I don't think it's possible (unless anyone else knows) You could possibly
create a user-defined function or put this formula into an adjacent cell:-

CONCATENATE(TEXT(INT(A2),"0")," ft ",TEXT((A2-INT(A2))*12,"0")," ins")