| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format
How do I change the date format from 06/07/2007 to June 07, 2007 in a text
string? this is what I'm using now "Evening Shift/Night Shift Checklist for " & Format(Now, "mm-dd-yyyy") thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date format
Format(Now, "mmmm dd, yyyy") NickHK "blackbox via OfficeKB.com" <u20390@uwe wrote in message news:73558009e62de@uwe... How do I change the date format from 06/07/2007 to June 07, 2007 in a text string? this is what I'm using now "Evening Shift/Night Shift Checklist for " & Format(Now, "mm-dd-yyyy") thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date format
that was easy...I feel dumb now
Thanks alot! NickHK wrote: Format(Now, "mmmm dd, yyyy") NickHK How do I change the date format from 06/07/2007 to June 07, 2007 in a text string? [quoted text clipped - 4 lines] thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| Convert european foreign date format to US date format | Excel Worksheet Functions | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
Hybrid Mode
