my auto number is start from 1 till 576 how to add CR- infornt ?

[paulyeo11]

Hi All

My autonumbering field is only number , possible to add CR- infront , and can the number starting from 100000 ?

so insteaf of 1 it will display as CR-100001

the number look more neat.

Paul

[tresesco]

try something like:

Load  'CR-' & 100000+Autonumber(Field)  as  FieldName

[#3 · Accepted solution]

Try this 

'CR-' & (100000+AUTONUMBER(Expression)) As Field

[paulyeo11]

your script work fine thank you.

[paulyeo11]

i think you work too , but need to add () bracket. thank you any way