I have data in a column and want to make them all 9 digits by adding 0 before them to make up any shortfall.
sample data;
29803
95448
106200
110458
110458
110470
i want to have:
000029803
000095448
000106200
000110458
thanks for your help
I have data in a column and want to make them all 9 digits by adding 0 before them to make up any shortfall.
sample data;
29803
95448
106200
110458
110458
110470
i want to have:
000029803
000095448
000106200
000110458
thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks