My Day✳All blog articles ↗

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.

004: 3 characters; 4: 1 character
004: 3 characters; 4: 1 character

What to do

  1. Find the source's exact codes and their item associations.
  2. Set the Excel input range to Text before transferring the codes.
  3. 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.

Buy My Day for Windows ↗