Should I convert every number-looking cell in our Excel stock sheet?
TechnologyThe imported quantity column has small green warnings beside entries such as 12 and 24. Excel says the numbers are stored as text. My helper wants to select the whole sheet and convert everything, including the adjacent item codes.
I only need the quantities to behave as numbers. The codes identify items; nobody needs to add them together. Microsoft documents Convert to Number and a separate-column method using VALUE. Microsoft's conversion guidance
Would you convert the quantity cells in place or keep a converted column beside the import first? This sheet will be updated from the same supplier again, so a quick fix that leaves us unsure what changed could become next month's problem.