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.
-Neil
Tags: