Forum Discussion
Date Formatting in Excel
No matter how many times I try and designate a Date format different than the default the newly designated format only works for one entry. I am using FORMAT>CELL>NUMBER>DATE to set the format. The c...
Here is Screen Shot. Dates are in the correct form as I have manually changed them one by one. This is about as simple as it gets, but I don’t know how to fix it. If I understand you I have to somehow indicate to Excel, in advance, that what is being entered is a date. If I don’t specify that, Excel will recognize it as a date after entry and default to the standard form.
Hi Michael,
First, some of your entries are not in correct date form (e.g. 1997--9-26, 1994-!-30, etc).
Dates in correct form, but entered as text, you may convert to dates by selecting Dates column, on ribbon Data->Text to Columns and on third step of the wizard select Date and YMD