Select the cells that will hold dates and set the date format you want. If you create your Excel report in LabVIEW from this template, the cells will use the formatting you set.
You can manually change a cell's format in Excel, and save the worksheet as a template. If you will be writing multiple data sets For example, if you're trying to convert the date '' from cell A1 into '', you can use the following text input for the Excel Easy Text.vi to display the date in the dd/mm/yyyy format: This will change the way Excel handles the cell data from the date format to a simple text string. If you prefer accomplishing the task programmatically, you can change the format of text before writing a timestamp by using Report Generation VIs by writing data in the text data type instead of timestamp datatype. In Excel, you can manually change the format of a particular cell by following Windows' instructions. MM/DD/YYYY, DD/MM/YYYY, etc.) based on your current location setting. Excel chooses the default regional date format (i.e. You can change the date format after completion of writing data to Excel by selecting a different locale. This is a simple method that you should use if you don't mind doing post-processing in Excel after writing your data.
#Formation labview manual
Manual Change Data Format in Excel (After Writing Data)