Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Date formatting | Excel Discussion (Misc queries) | |||
Date formatting | Excel Discussion (Misc queries) | |||
Date Formatting | Excel Discussion (Misc queries) | |||
Date Colum Date Formatting & Validation | Excel Programming |