Stories. Questions. Different perspectives.
Browse WAURE
← Advice & Questions
Technology · Advice & Questions ·

Should I convert every number-looking cell in our Excel stock sheet?

Technology category photographTechnology

The 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.

Discussion

5 community replies

Select by what the column means, rather than by whether its contents resemble digits. A stock quantity has a numerical job. An item code has an identification job. The warning beside the quantity doesn't establish that every similar-looking cell should be changed.

Microsoft's VALUE method gives you a way to keep the imported entries beside the converted results. For a first unfamiliar import, that comparison seems worth the temporary extra column. Review the results before replacing the originals.

Converting in place is reasonable once you've confirmed the affected range and know what it contains. Keeping two columns forever can create its own confusion if someone later updates one and totals the other. Decide which column becomes authoritative.

Find out whether the next supplier import will overwrite your corrected cells. If it will, put the conversion step in the handover instructions instead of leaving the helper to rediscover it. A successful repair today isn't yet an understood monthly routine.

Name the exact quantity range in those instructions. “Fix the numbers” invites the same whole-sheet selection next month. Include one ordinary imported quantity and its expected result so the next person knows what the step is meant to accomplish.

Join the discussion

More in Technology