I've an issue with access actually I don't know how I can do that. I have an excel file with numbers from 4 till 12 digits. I need to fill them with 0 till they become 13 digits but 4, 5 and 12 digits should stay like they are.
Exp: 123456 - should be 0000000123456 123456789 - should be 0000123456789 1234 - should stay as 1234
Could someone be so kind and help me in this issue?
Format(x,"000000000000")
. Second case you need to change the number format of the field / column containing your data.