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 RJ
If your date is in cell B1 then try this =TEXT(DATEVALUE(B1),"ddd")
- Si am having an issue that sims to be in this ball park if it is not please direct to where i should go.
I have been working on a file where i take weight x ft x 3 = formula on export i get the formula expression instead of the actual formula result.
How can i export as the result instead of the formula- Hi, could you start a new post with your question
More chance of getting a response and it’s best to avoid mixing questions
Thanks
Thank you, Wyn but this does not work either.
I feel like there is some sort of hidden formatting or switch that has been toggled when the file is exported from the database. Like I said, sometimes my first attempt and your suggestion do work.
Hi RJ,
Is "dd/mm/yyyy" your regional settings format for the dates?
