Thread: display number as feet and inch in single cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default display number as feet and inch in single cell
It can be done with a formula:
=INT(A1)&CHAR(39)&"-"&MOD(A1,INT(A1))*12&CHAR(34)
....but I don't know if there is a way to create a custom format to do
it.

Reply With QuoteReply With Quote