Forum Discussion
#SPILL! From a Referenced Merged Cell.
Sure, Excel will format dates for you just like it formats phone numbers. The number format
[$-en-US]mm/dd/yyyy
will do it. The catch is that you need to enter
44119
(the number of days elapsed since the start of the 1900s)
PeterBartholomew1 yes, that is exactly what's going on here. I don't know why Microsoft did it this way. The average consumer does not think in terms of "days since 1900." I'll just continue to type the dates in long form. Thanks!
Datetime is continuous and sequential. In all cultures it starts from one day which people agree to consider as beginning of their history, after that only representation of the dates counted from that very beginning. Same in software programs, the only difference that's the start date which is chosen. Excel for Windows takes Jan 01, 1900.
Phone numbers are random and have no links with each other, you may take them as it is and apply any format you wish.
You may imitate date format for numbers like
but it'll be the number as in formula bar which can't be calculated as a date and can't be validated as a date.
Ah, that would be because Excel's dates are designed to support calculation.
Your 'long form' comprises the number of times the moon has circuited the Earth, with part periods represented by the number of times the Earth has rotated on its axis and finishing with the number of times the Earth has circuited the Sun since some event deemed to be of importance. BTW, why do you place the smallest interval in the middle?
You see the problem?
