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.

Why is my number stored as text in Excel? Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting.

The automatic conversion function of Excel, Microsoft's spreadsheet software, automatically converts some inputs, such as numbers and dates, into specific types of data. Although this feature is ...

How to Convert 5-Digit Julian Dates to Regular Dates in Excel. The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit ...

Type an apostrophe before entering or pasting two numbers separated by a hyphen in Microsoft Excel to keep the numbers from being converted to their month and date equivalent.