Forum Discussion
Function =text(cell,"ddd") fails to convert a date to a day
I am exporting data from a database. Column B contains a date/time and looks like this: 01/01/2017 07:10:59. If you select column B, the column type is "text." I use the "text to columns feature," ...
Hi Tony20z220
I'm using 'ddd' in my formula but the name of the days are coming in Spanish. My computer language is English though. Do you know how can I make them come in English?
Thanks!
If the formula works, but the result is in the wrong language, I would start checking language settings in Excel or Windows. They may be set to english but have a different region so excel is using the region to decide the language for the formula. That would be my guess.
Excel uses regional settings to recognize dates and current language to perform operations on it by formula.
