Thread: Formatting Numbers and Fractions in Excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
monarcabak monarcabak is offline
external usenet poster
  
Posts: 2
Default Formatting Numbers and Fractions in Excel
Thank you!!

"David Biddulph" wrote:

=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