I see this happening all the time when I download data from databases or web-based tools. ![]() This is also the reason that sometimes you may expect a date in a cell but end up seeing a number. In Microsoft Excel for Windows, “” is stored as 1, “” is stored as 2, and so on.īelow, both columns have the same numbers, but Column A shows numbers and Column B shows the date that’s represented by that number. This is useful as it also allows users to easily add/subtract date and time in Excel. This means that while you may see a date such as “10 January 2020” or “” in a cell, in the back-end, Excel is storing that as a number. Excel stores date and time values as serial numbers in the back end.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |