i have been given a spreadsheet with a particular column which i need to query.
i have transfered the data to an access db and now i want to format that column to have 8 numbers.
below is the column which i want to format. The format criteria is that it has to start with at least one 0 and the total number of characters must not exceed 8.
search
0000000029402
0000000029855
0000000030416889
0000000030524830
0000000095A495
0000000095A496
0000000095A798
0000000095C049
000000009000189
00000000990702
00000000994831
00000000919645
00000000919646
00000000919647
how can i do this??
thanks.