I have a workbook that feeds information from each worksheet into another worksheet. On the customer tab you have to number the customer and then enter the information. It worked fine with customers 1-9, but when I entered customer 10 Excel only sees the one and keeps picking up customer number 1 info where customer 10 info should be. This is a problem because it's generating invoices and the wrong customer number being used is creating invoices to the wrong customer.
How do I get excel to recognize "10" as "10" and not "1"?