convert number to dozen showing remainder

H

hayescircus

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

edvwvw via OfficeKB.com

=INT(A1/12)&" doz "&(MOD(A1,12))&" ea"

The value in aA1 should be a number

edvwvw
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
calculating a remainder field 0
Line Numbers Will Not Show 0
Disabling auto-numbering in headings when converting PDF to Word 0
Convert numbers stored as text to numbers - Automatically - Macro 2
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA) 0
WordPerfect to Word Conversion Footnote Problem 0
How to get different base systems so letters will show up like hex system tia sal2 1

Top