Thread: convert number to dozen showing remainder
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
edvwvw via OfficeKB.com edvwvw via OfficeKB.com is offline
external usenet poster
  
Posts: 79
Default convert number to dozen showing remainder
=INT(A1/12)&" doz "&(MOD(A1,12))&" ea"

The value in aA1 should be a number

edvwvw

hayescircus wrote:
Trying to convert a number to show dozen with remainder. ie:
convert 29ea to 2dz 5ea

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/201003/1

Reply With QuoteReply With Quote