you can also do it by syntax:
Code: Select all
compute var1n = number(variable1, f8.2).
compute var2n = number(variable2, f8.2).
if you just place your variable names in one column in excel, and the rest of the syntax in other columns, you can easily create such a syntax for 3000 variables in a few minutes using drag or copy paste.