Dozens formula

[Mark]

In my business we calculate our items by dozens:
154 = 12/10
26 = 2/02
IS there any way to make a formula read a cell with 154
any answer with 12/10?

Thanks

 

[Dave R.]

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

tho with this, you won't get 2/02 you'll get 2/2.

 

[Jason Morin]

=INT(A1/12)&"/"&TEXT(MOD(A1,12),"00")

HTH
Jason
Atlanta, GA

 

[Dave R.]

Here is one more all-encompassing including only "2" instead of "2/0" for
24.

=CHOOSE((MOD(A1,12)=0)+1,INT(A1/12)&"/"&TEXT(MOD(A1,12),"00"),A1/12)

 

[Guest]

-----Original Message-----
In my business we calculate our items by dozens:
154 = 12/10
26 = 2/02
IS there any way to make a formula read a cell with 154
any answer with 12/10?

Thanks

.