Cell Format
 

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

Cell Format
 

"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")

Cell Format
 

Thanks for the help I will keep trudging thru this spreadsheet.

"bigwheel" wrote:

"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")

Cell Format
 

It's a pleasure and thanks for the feedback.

"rk@morsesteel" wrote:

Thanks for the help I will keep trudging thru this spreadsheet.

"bigwheel" wrote:

"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")