software

I need a cell that will concatenate a message quot;User Added by Glenda on quot; and
then today's date in mm/dd/yyyy format.
I'm trying
= quot;User Added by Glenda on quot;amp;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 quot;user added
byquot; cell I still got this number 37307.
What am I doing wrong?

Use TEXT to format the date:
=quot;User Added by Glenda on quot; amp; text(today(),quot;mm/dd/yyyyquot;)

quot;Glendaquot; wrote:

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