|
MM/DD/YYYY format Today
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? |
MM/DD/YYYY format Today
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? |
| All times are GMT +1. The time now is 09:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com