I'm making a finance plan, where I have the columns 'Quantity', 'Cost' and 'Total'.

The quantity column will contain how many of the item I buy.

The Cost column will have the individual cost of the item.

The total column will have, using excel formulas, the PRODUCT of the quantity cell and cost cell. For example, if I buy 2 of one item that costs $2 each, the total cell will contain the formula "=PRODUCT(QTY:COST)" to produce $4.

My dilemma is, that I want to be able to have both words and numbers in the quantity cell, but still have the formula in the total cell to work. For example, if I buy two packets of something, I want to write in the quantity cell '2 pkt' instead of just '2', but when I do this the total cell does not pick up the number in the quantity cell and just gives me 1 x Cost when it should give me 2 x Cost.

Is there any way to fix this while still using formulas, so I don't have to enter all totals manually? Any help appreciated!