View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
rexie3 rexie3 is offline
external usenet poster
 
Posts: 14
Default 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.