I'm sorry, it makes no sense to me. You can put 400 in a cell, or you can put $5.00 in a cell, but you cannot put two values in a cell.



Perhaps if you explained your business need instead of dictating how it should be accomplished, it would work better.

Sorry, guess I didn't explain myself very well.
OK the number in column A1 is the length of timber, and text in column B1 is the type / style of timber.
So to make it very easy for our packing staff the send invoices off, if they just needed to put the length of the timber in and the code for type / style, they wouldn't have to work out the cost themselves.

Hope that helps a little

Thanks