1-2-3

Thank God all my spreadsheet training was delivered to me in the 1980s.

The new corporate monitoring spreadsheet has been made available and needs to be filled in with the new payroll numbers for all members of staff (if you've not been sick a null event entry has to be submitted). Unfortunately, all they're all six-figure numbers starting with 000 and the payroll number column is number-formatted so that 000001 is recorded as 1 and the submitted spreadsheet is sent back with a "no such payroll number" message attached to it.

Smugly, I tell Maybelle to stick an apostrophe in front of the payroll numbers. et voilà!