Use TEXT to format the date:
="User Added by Glenda on " & text(today(),"mm/dd/yyyy")

"Glenda" wrote:

I need a cell that will concatenate a message "User Added by Glenda on " and
then today's date in mm/dd/yyyy format.
I'm trying
= "User Added by Glenda on "&Today()
the today comes back as the number 37307. I understand that this is the
37307 day from ... I tried to change the format by going to the tools menu
and options and Calculations and 1904... I even tried to insert another
column to hold the date and then push them together and in the "user added
by" cell I still got this number 37307.
What am I doing wrong?