Trying to convert a number to show dozen with remainder. ie: convert 29ea to 2dz 5ea
H hayescircus Mar 17, 2010 #1 Trying to convert a number to show dozen with remainder. ie: convert 29ea to 2dz 5ea
E edvwvw via OfficeKB.com Mar 17, 2010 #2 =INT(A1/12)&" doz "&(MOD(A1,12))&" ea" The value in aA1 should be a number edvwvw
