# Automatic numbering

#### Humphrey

##### New Member
Hi everyone,
I have defined a new variable in my SPSS file. This is students' IDs. I want to number them from 1-6543. How can I automatically do it?
How can I tell the programm to write form 1 to 6543 in one column?
I really do not want to do it by hand.
Thanks for your help
Humphrey

#### Remo

##### New Member
A quick and dirty way to do things like this is to use the auto series fill function in Excel to drag down to the number you need in a column then copy that data into SPSS. Its not a programmers solution to be sure, but its quick and it works.

Remo

#### statistician

##### New Member
Try this:

COMPUTE id = $CASENUM . EXECUTE . If you know nothing on syntax, try this: Transform -> Compute -> in the numerical expression, type '$CASENUM'