Every time I paste a 7-digit employee ID like 0012345 into Excel 365, it silently turns it into 12345 and our CSV import spits back an error on line 642. Is there a dead-simple way to make one column permanently treat IDs as text so I don’t have to babysit it every morning?
Set that column to Text first (“Home > Number Format > Text”), then paste — Excel stops dieting away your zeros, and unlike a custom 0000000 format it also survives CSV export… If you want it to stick, convert the range to a Table and set that column’s format to Text so it persists for new rows. Do you paste into the same sheet every morning?
Power Query: import via ‘From Text/CSV’, set the ID column type to Text, then just refresh. @OP.
Make an.xltx template with ID column Text; paste keeps ‘0012345’. CSV export preserves zeros.