Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date question
Have
..Range("I2").Value = Format(Date, "dddd dd mmm yyyy") Cannot find how to change this to give the full value for the month, rather than a truncated version. How is this done, please? Regards. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date question
"Stuart" wrote in message
... Have .Range("I2").Value = Format(Date, "dddd dd mmm yyyy") Cannot find how to change this to give the full value for the month, rather than a truncated version. Hi Stuart, Just add a fourth "m" to the month string. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date question
Many thanks to you both.
Regards. "sebastienm" wrote in message ... To display the full month, use 4 'm': dd ddd mmmm yyyy -- Regards, Sébastien --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date question
Are you sure that you want to set text in the cell?
You'll lose some flexibility as an alternative With Range("I2") .Value = Date .NumberFormat = "dd mmmm yyyy" End With -- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "Stuart" wrote in message ... Many thanks to you both. Regards. "sebastienm" wrote in message ... To display the full month, use 4 'm': dd ddd mmmm yyyy -- Regards, Sébastien --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date question
Macro Recorder broken again?
-- Regards, Tom Ogilvy "Stuart" wrote in message ... Many thanks to you both. Regards. "sebastienm" wrote in message ... To display the full month, use 4 'm': dd ddd mmmm yyyy -- Regards, Sébastien --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date question | Excel Discussion (Misc queries) | |||
Date question?? | Excel Discussion (Misc queries) | |||
Date question | Excel Worksheet Functions | |||
Date question | Excel Worksheet Functions | |||
Another Date Question | Excel Discussion (Misc queries) |