FORMATING

[JASON]

I have a spreadsheet that has a column that is formated
as general. this column has 16 digit account numbers in
it. all account #s are preceeded by "'" I have tried
formating the column as text, general, numerical and then
tried a find and replace to remove the 1st character "'"
and once I do it then changes the account # to read
54634+e. Is there something I can do in a macro to
remove the 1st character of each account #?

Jason

 

[Guest]

I would insert a column next to the one containing the account numbers and use the RIGHT fn. If the Account Numbers are in column A, then put "=right(a1,16)" in b1 and copy down the column. That should work, unless there is something funky with the account numbers to begin with. Were they imported from another program?

 

[Guest]

I believe so

-----Original Message-----
I would insert a column next to the one containing the

account numbers and use the RIGHT fn. If the Account
Numbers are in column A, then put "=right(a1,16)" in b1
and copy down the column. That should work, unless there
is something funky with the account numbers to begin
with. Were they imported from another program?