easy5 pts · first answer countsdata-cleaningexcel
Lost leading zeros in IDs
After importing a CSV into Excel, employee IDs like 00451 now show as 451. What is the best fix?
Discussion 0
Join free to post in the discussion.
Related questions
- What a pivot table doesData Analyst
- Absolute references in ExcelData Analyst
- VLOOKUP returns wrong pricesData Analyst
- SUMIFS with two conditionsData Analyst
- Filling missing income valuesData Analyst
- Looking up a value to the leftData Analyst
- Share of sales in a pivot tableData Analyst
- Pivot ignores new data rowsData Analyst