Forum Discussion
Exporting UPC's into Excel
I'm exporting our inventory into Excel to make re-ordering easier (that part is simple). My problem is there are a lot of UPC's that start with 0 (I have 15,000 items in this spreadsheet). The 0 do...
Misqueet ,
Better to adjust your importing procedure not to convert texts to numbers. If not, you may correct with helper column. Assume your UPC:s are in column A starting from A1
- select it, Ctrl+1 and format as text
- in B1 type the formula
=IF(LEN(A1)=11,A1,"0"&A1)
- stay on B1, in the left up box under it with address (shall be shown B1) type B15000 or what is your last cell in the range
- press Shift and Enter (entire range in B shall be selected)
- Ctrl+D (formula will be populated till end of the range)
- select column B, copy it, select column A and Paste special as values here
- delete column B