![]() |
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 |
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?
|
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