From: John on
For example how to convert 13.25' to 13'-3" ?
From: Mike H on
John.

With your decimal value in a1 try

=INT(A1)&"' "&INT(12*(A1-INT(A1)))&""""
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

> For example how to convert 13.25' to 13'-3" ?
From: Mike H on
see your other post
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"John" wrote:

> For example how to convert 13.25' to 13'-3" ?
From: Rick Rothstein on
If you are talking about showing your conversion in another cell, then you
can use this formula...

=INT(A1)&"'-"&12*MOD(A1,1)&""""

--
Rick (MVP - Excel)


"John" <John(a)discussions.microsoft.com> wrote in message
news:B5FA64B6-7F8E-4B3C-A217-586768DEAF51(a)microsoft.com...
> For example how to convert 13.25' to 13'-3" ?