Forum Discussion
Martin Bønnelykke Jensen
Nov 01, 2018Copper Contributor
Datevalue() from text, English not recognized
Dear all
I'd like some help. Most likely the screenshot explains it.
Datevalue(januar 2016) returns 01-01-2016
Datevalue(january 2016) returns #Value
My sheet is in English
My Excel is in English
My windows is in English
My windows date settings are in Danish
The users of the excel documents windows date settings will be Danish, Polish, Romanian, French, Estonian.
Any suggestions how to solve my issue on a global scale?
Thanks
- Martin Bønnelykke JensenCopper Contributor
I didn't find where to put my post under the help section, and don't know how to move it. Sorry. Can anyone help?