Dear all,
I have excel sheet which contains some card number. It start from 1 upto 9999.
But other system needs to recognize those number as 8 length fixed number. 000001 - 009999.
If I read the excel date, the number was converted to 1 - 9999.
Is there any method to output the number as 000001 - 009999 ?
Thank you very much.