Thread: Date formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 270
Default 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