pbdsp79
10-26-2007, 08:47 AM
Hi All
Having a excel file, in which there are two sheets, one is INPUT and other is RESULTS.
In input sheet A1 is named as CUSIP, under which we input various alphnumeric figures, and in results sheet, we want that all alphanumeric figures should turn into 9 digits.
for eg.in input if it is 123456, than in result it should become 000123456 ie 9 digits.
for eg.if we input asd78 in input sheet, it should reutrn us 0000asd78
I have tried from my side, but i am not able to find solution, seeking help form you.
I am attaching excel file for ur reference, in which the way i want the results is also there, that is i have manually inserted zeros to make it 9 alphanumeric, now i want that once i input alphanumeric digits in input ssheet, it shoudl automatically change to 9 alpahnumeric digit in reult screen.
Regards
Prashant
Having a excel file, in which there are two sheets, one is INPUT and other is RESULTS.
In input sheet A1 is named as CUSIP, under which we input various alphnumeric figures, and in results sheet, we want that all alphanumeric figures should turn into 9 digits.
for eg.in input if it is 123456, than in result it should become 000123456 ie 9 digits.
for eg.if we input asd78 in input sheet, it should reutrn us 0000asd78
I have tried from my side, but i am not able to find solution, seeking help form you.
I am attaching excel file for ur reference, in which the way i want the results is also there, that is i have manually inserted zeros to make it 9 alphanumeric, now i want that once i input alphanumeric digits in input ssheet, it shoudl automatically change to 9 alpahnumeric digit in reult screen.
Regards
Prashant