View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.