| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date formatting
Sandy,
Try this Range("A1").Value = "You have selected rounds between '" _ & Format(Range("B4"), "DD MMMM YY") & "' and '" & Format(Range("F4"), _ "DD MMMM YYYY") & "'" Mike "Sandy" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date formatting
Ah the parentheses make all the difference - I nearly had it.
Thank you very much Mike Sandy "Mike H" wrote in message ... Sandy, Try this Range("A1").Value = "You have selected rounds between '" _ & Format(Range("B4"), "DD MMMM YY") & "' and '" & Format(Range("F4"), _ "DD MMMM YYYY") & "'" Mike "Sandy" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date formatting
Your welcome and thanks for the feedback
"Sandy" wrote: Ah the parentheses make all the difference - I nearly had it. Thank you very much Mike Sandy "Mike H" wrote in message ... Sandy, Try this Range("A1").Value = "You have selected rounds between '" _ & Format(Range("B4"), "DD MMMM YY") & "' and '" & Format(Range("F4"), _ "DD MMMM YYYY") & "'" Mike "Sandy" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
