T
The Rook
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
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