My computer did the same thing as NBVC's. If you have a lot of that formula in the column, rather than using F2 on each one, you can select the column and do Text to Columns>Finish. That changed the dddd to Tuesday for me. (Text to Columns is on the Data tab of your ribbon).