Preserve leading zeroes in work identifiers
Transfer identifiers as text instead of guessing their width after characters are lost.
A code can contain digits while remaining a name, not a number for calculation. Its initial zeroes may be part of its identity. In Excel, set Text before entry or pasting. Recover lost characters from the source, not a guessed width.
What to do
- Find the source's exact codes and their item associations.
- Set the Excel input range to Text before transferring the codes.
- Compare every character and item association, including initial zeroes.
Example
Fictional source: “004—red folder; 4—blue folder.” After text entry, 004 retains 3 characters and 4 retains 1. The codes remain different. Converting both to number 4 loses that distinction. A 000 display pattern cannot tell you which original code was intended; consult the source.
My Day · Windows
Manually save this personal record in My Day.