Date formatting
Excel 2003
I have dates in Cells B4 (10 March 2007) and F4 (20 October 2007).
Formatting is "dd mmmm yyyy".
I have, as part of a macro:-
Range("A1").Value = "You have selected rounds between '" & Range("B4") & _
"' and '" & Range("F4") & "'"
which produces:-
You have selected rounds between '10/03/2007' and '20/10/2007'
I would like it to read:-
You have selected rounds between '10 March 2007' and '20 October 2007'.
How can I adjust my code to produce this result?
Sandy
|