ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FORMATING (https://www.excelbanter.com/excel-programming/298995-formating.html)

jason

FORMATING
 
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

Marcotte A[_2_]

FORMATING
 
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?

No Name

FORMATING
 
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?
.



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com