Forum Discussion
Date formatting and autosave
Hi all. I am trying to create a form that will have VBA Macro to save the file based on a cell content. Now to make that cell content it is pulling data from other cells: =B2&" "&G2&" "&K2 But i ...
You can use the TEXT function to format the date:
=B2&" "&G2&" "&TEXT(K2, "yyyymmdd")
or
=B2&" "&G2&" "&TEXT(K2, "dd-mm-yyyy")