I wonder if anyone can help me, i need to work with some items in dozens, i have seen sheets such as mine that have been formulated to count and subtract in dozens but I have no idea how to do it for example 1.1 + 1.11 = 2 or 1.1 + 1.10 = 2.11



I would like the units on my sheet marked as dozens to perform the same as the units that count in gallons or singles.

I am very grateful to anyone who can help

Attached Files

Example stock.xls (72.5 KB, 15 views)

I did find this when searching, could it be adapted for my sheet

=DOLLARDE(SUBSTITUTE(A1,"-","."),12)*12

This is a clearer example of what i am needing help with
I would like to be able to enter and show the dozens as 1.02 + 1.06 =2.09

I send thanks anyone who can help me .

Attached Images

Capture.PNG (50.3 KB, 19 views)

Could you please post a sample sheet ( not a pic), showing some examples of data and expected results ? Which are your regional settings ?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you for your reply, this is what I would like the sheet to do I am using Windows 7 pro and office 2007
the profit column removes cost and UK Vat at 20% from the sales at retail getting the colums to count in dozens is my main problem

Attached Files

Book1.xlsx (11.4 KB, 15 views)