Numbers that are stored as text in Excel can cause unexpected results. You need to convert numbers stored as text to numbers. Here's how!

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

Select cells from which you want to divide text. Click Text to Columns under the Data tab. Select Delimiters, glance over the preview, and click Next. Hit Finish and you are good to go.