M madhusudhana New Member Nov 3, 2019 #1 Dear sir I have Received mail from bank (ms word file) and copied in excel file with out a problem but the values are saving text format even i have converted into numerical format it is getting error. please solve Attachments Book11 - Copy.xlsx 10 KB · Views: 4
Dear sir I have Received mail from bank (ms word file) and copied in excel file with out a problem but the values are saving text format even i have converted into numerical format it is getting error. please solve
N NARAYANK991 Excel Ninja Nov 3, 2019 #2 Hi , See the attached file. Basically , the number strings all have non-numeric characters both before and after the digits. You need to use a formula to remove these. Narayan Attachments Book2 (3).xlsx 11.1 KB · Views: 12
Hi , See the attached file. Basically , the number strings all have non-numeric characters both before and after the digits. You need to use a formula to remove these. Narayan