Thread: Formatting Numbers and Fractions in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 618
Default Formatting Numbers and Fractions in Excel
=INT(A1)&" lbs "&16*MOD(A1,1)&" ounces"
--
David Biddulph

"monarcabak" wrote in message
...
How can I display a cell with the number 2.5 as 2 lbs 8 ounces?

Thanks
Alfredo Livas


Reply With QuoteReply With Quote