username & date together

[ExcelRoy]

Hi all,

Is there a way to have the username and date displayed together

=username()&NOW() displays a number after the username

Thanks for any help

 

[Joe4]

That is because dates are actually stored as numbers, specifically the number of days since 1/0/1900. You just need to tell it how you want it formatted.
In VBA, that would be the FORMAT function. On the worksheet, that would be the TEXT function, i.e.
TEXT(NOW(),"mm/dd/yyyy")

 

[ExcelRoy]

That's perfect many thanks