Forum Discussion
Date formating
Results from a query in Date column won't change format unless I physically go into the cell and press enter. So, other than pressing F2&Enter, how can I get the format to take on all cells in column...
Thank you. Unfortunately, the report is delivered from outside source. I ended up splitting text to columns then concatenated the values, changed text to date and it worked.
Good to know you sorted this out. As a comment, most probably you don't need to split on columns, all could be done within one column.