TIP: Calculations on an AutoNumber Column

NeilKY

I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000.

You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT NUMERICAL PLACES if you want to use it in a calculation.

I couldn't find this info anywhere else so hopefully this helps someone avoid a headache in the future.