| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
| When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions | |||
Hybrid Mode
