View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
 
Posts: 70
Default Date Formatting when using &

A1 is currently populated with a date, custom formatted as dd-mmm-yy. A2 is
populated with =text(a1,"DDDD") to show what day this is.

What I am wanting to do is put them both togther to show the Day in text
along with the date as custom format dd-mmm-yy. I have currently entered:

=a2&" "&a1, but this shows thae date as a number. How can I format it so it
show as I require it or is there a format to show it as this anyway?

regards