Hi Everyone, Sometimes we export data from our Softwares to Excel files and find that some data is looking as Numbers but not behaving as Numbers and same is the case with Dates as well. Here in this article, I have tried to overcome this problem with a procedure OR code which will convert the Numbers and Dates stored in Text format to their respective formats. Here are the steps:- 1. Select the Range. The Range should be one columnar Range. Preferably select whole column at a time. 2. Click "Text to Column" Option in Data Tab. 3. Select "Delimited" Option, and click Next. Uncheck all the Dilimiter options. 4. Click Next Again and then click Finished. That it. Now, you will notice that the format has changed.
Custom Excel Solutions.. ( Excel Functions and Vba )