Hi All:
I was wondering if there is a VBA Code that will convert a Cheque Number something like:
C3232456 or CS-323232 or SA2323-1A
to a number? Why I ask is that when I try to upload my sheet to Access any cheques with an ALPHA in it are not being uploaded. This is because the table it is uploading to is formatted as number. I tried changing the formatting in Access to Text but it keeps reverting back to Number. I did not create the Access Database so I am not sure exactly how to change it and prevent it from reverting back. Also , there is probably a reason that it is formatted that way.
So what I am looking for is something that would:
Select "Cheque Logging Sheet"
Make anything in C2 to C251 a NUMBER regardless of what is entered.
Any ideas?
THANKS,
Mark
I was wondering if there is a VBA Code that will convert a Cheque Number something like:
C3232456 or CS-323232 or SA2323-1A
to a number? Why I ask is that when I try to upload my sheet to Access any cheques with an ALPHA in it are not being uploaded. This is because the table it is uploading to is formatted as number. I tried changing the formatting in Access to Text but it keeps reverting back to Number. I did not create the Access Database so I am not sure exactly how to change it and prevent it from reverting back. Also , there is probably a reason that it is formatted that way.
So what I am looking for is something that would:
Select "Cheque Logging Sheet"
Make anything in C2 to C251 a NUMBER regardless of what is entered.
Any ideas?
THANKS,
Mark