Forum Discussion
Solved
Cant understand why i cant apply formula
Good day, i'm hereby asking for help : I'm trying to apply formula ( =TEXT(E2,"mm/dd/yyyy hh:mm") but its giving me this error: and im not able to fix it, could you please find the...
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
SergeiBaklan semicolon worked, thank you so much:)
now the new issue -> instead of year it shows YYYY, do you know maybe how to fix that?
And what is in formula bar for E2?
- i think the issue that im using CZ locale, its really pain
Most probably yes, data format you use doesn't meet your locale settings.
- mm/dd/rrrr h:mm