I would like to record dozens and single units in single cells with a view to
using them in calculations. E.G. stock sheet -

12,4 in one cell added to 10,2 in another cell resulting with an answer 0f

22,6 in a third cell with the 22 representing 22 dozen items and the 6
representing 6 single items.

Hi,

With your 2 numbers in a1.B1 try this

=(LEFT(A1,FIND(",",A1)-1))+LEFT(B1,FIND(",",B1)-1)&","&MID(A1,FIND(",",A1)+1,LEN(A1))+MID(B1,FIND( ",",B1)+1,LEN(B1))

Mike

"Calculating Dozens" wrote:

I would like to record dozens and single units in single cells with a view to
using them in calculations. E.G. stock sheet -

12,4 in one cell added to 10,2 in another cell resulting with an answer 0f

22,6 in a third cell with the 22 representing 22 dozen items and the 6
representing 6 single items.

"Calculating Dozens" wrote:

I would like to record dozens and single units in single cells with a view to
using them in calculations. E.G. stock sheet -

12,4 in one cell added to 10,2 in another cell resulting with an answer 0f

22,6 in a third cell with the 22 representing 22 dozen items and the 6
representing 6 single items.

You could also use the trick of separating the two numbers with a decimal
point. Use a very large number of places to avoid overflow. So for example
the numbers could be 12.000004 and 10.000002 adding them gives 22.000006
The numbers can also be separated very easily using the =int function