Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
convert number to dozen showing remainder
Trying to convert a number to show dozen with remainder. ie:
convert 29ea to 2dz 5ea |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rolling over a Remainder | Excel Worksheet Functions | |||
Divide number and add remainder in another cell | Excel Discussion (Misc queries) | |||
Remainder | Excel Discussion (Misc queries) | |||
remainder in a division | Excel Worksheet Functions | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |