HOW TO CONVERT INTO NUMERIC VALUE

[madhusudhana]

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

 

[NARAYANK991]

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

 

[madhusudhana]

thankyou very much sir

 

[Hany ali]

madhusudhana
why you didn't Click Like ?!!!!!!!!!!!

 

[madhusudhana]

yes i clicked like