1 open your excel workbook and then click on Visual Basic command under DEVELOPER Tab or just press ALTF11 shortcut. In the Type field edit the number format codes to. Today is.
To do this embed the TEXT function in your Excel concatenate formula.
To do this I will have to create a formula and get the result in a separate cell. In the first argument value you supply a number or date to be converted to text or a reference to the cell containing a numeric value. In the Type field edit the number format codes to. Modify and copy the.