![]() If the stored data complies with Date syntax (as in that 1st example) you can simply copy the numberġ from any cell, select the target cell(s) & use Edit> Paste Special - Multiply to convert the entries to their respective serial date values, then format the cell(s) using the preferred Date Format. Note that the only distinction between the 2 examples is the The former is treated as a Date as long as the cell isn't already formatted as Text, but the latter is treated as Text regardless of how the cell is formatted. I'm not sure what to suggest for resolving the issue because the examples you're giving all vary in some regard. Both PC Excel & Mac Excel operate identically in that regard. ![]() As I explained in my reply to that message, neither However, the date stored as Text must be in a form which Excel recognizes as valid date syntax. ![]() If you format the cell containing that date as Text, the DATEVALUE function will work, i.e., return the serial value for that date or display itĪs a Date depending on the formatting of the cell containing the function. Renders the #VALUE error - as I mentioned before, that function cannot be applied to a date stored as a Date. That's why referring to that cell using DATEVALUE When you enter Janu(or any compliant Date) into a cell formatted as General the cell is automatically reformatted as Date because the entry is recognized by Excel as valid Date syntax. Going back to the example in your message of June 28.
0 Comments
Leave a Reply. |