CesarAustin
Board Regular
- Joined
- Aug 21, 2004
- Messages
- 147
Hope someone can help me, I have a table with one column with numbers from 1~999 I need to do some kind of update quarry or something to change the 1 and 2 digits to 3 digits… example: number 1,2,3 changed to 001, 002, 003 etc.. I have no idea how to do that without exporting the information from access to excel then manually changing the numbers in excel. Any help would be great.. Thanks all