| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text and today's date in 1 cell
I need to set up a cell to have today's date with the user's initials. For
example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and today's date in 1 cell
=A1&TEXT(TODAY(),"yyyy/mm/dd")
if the initials are in A1 -- Gary's Student gsnu200705 "rexie3" wrote: I need to set up a cell to have today's date with the user's initials. For example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and today's date in 1 cell
="ABC "&TEXT(TODAY(),"YYYY/MM/DD")
-- David Biddulph "rexie3" wrote in message ... I need to set up a cell to have today's date with the user's initials. For example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and today's date in 1 cell
Rexie,
You could put =TODAY() in the cell, and format it (Format - Cells - Number - Custom tab: -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "rexie3" wrote in message ... I need to set up a cell to have today's date with the user's initials. For example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and today's date in 1 cell
Thank you so much! Now my headache is half gone...finally. I have another
posting that's much more complicated. "Gary''s Student" wrote: =A1&TEXT(TODAY(),"yyyy/mm/dd") if the initials are in A1 -- Gary's Student gsnu200705 "rexie3" wrote: I need to set up a cell to have today's date with the user's initials. For example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
text and today's date in 1 cell
Thank you David. Once again the Community has saved my brain.
"David Biddulph" wrote: ="ABC "&TEXT(TODAY(),"YYYY/MM/DD") -- David Biddulph "rexie3" wrote in message ... I need to set up a cell to have today's date with the user's initials. For example, ABC 2007/02/08. How do I do this? Please notice that the date format is European. Thanking you in advance for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using TODAY function to return a date as text | Excel Discussion (Misc queries) | |||
| Combine text and today's date in a cell | Excel Worksheet Functions | |||
| Text & Date in the same Cell??? | Excel Worksheet Functions | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
