Forum Discussion
Cant understand why i cant apply formula
Yes, only applying the format won't convert text to date. How to convert it depend what is your OS default format. As variant you may use Text to Columns - first split on date and time, when to date apply wizard with MDY format on third step, combine date and time back.
If that's your native format you may convert by adding zero, with Paste Special ->Add or by formula
thanks for reply, originally it was text - i changed to custom type : but seems it didnt work 😞
so i should convert to Numbers firts and than to custom type? thank you again
Yes, only applying the format won't convert text to date. How to convert it depend what is your OS default format. As variant you may use Text to Columns - first split on date and time, when to date apply wizard with MDY format on third step, combine date and time back.
If that's your native format you may convert by adding zero, with Paste Special ->Add or by formula