I have a drop down list with numbers from 1 to 20 which I use in a form. The numbers when sorted appear like this:
13
14
15
1
2
3
4
I would like to change numbers 1 to 9 to 01, 02 etc so that numbers when sorted appear like this:
01
02
03
However i am afraid to edit the numbers in the drop down list as I'm not sure if the data will automatically refresh i.e. if a record was 1 and now in the list there is only 01, will the record automatically be associated with 01?
I hope I'm explaining my problem clearly!
13
14
15
1
2
3
4
I would like to change numbers 1 to 9 to 01, 02 etc so that numbers when sorted appear like this:
01
02
03
However i am afraid to edit the numbers in the drop down list as I'm not sure if the data will automatically refresh i.e. if a record was 1 and now in the list there is only 01, will the record automatically be associated with 01?
I hope I'm explaining my problem clearly!