Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date
Hi, sorry to bother you all with a mundane problem but my
help file won't work and i can't get anything out of it. i've got a program which needs the date putting in very often. a userform pops up at the beginning to check that it has the correct date, and then fills all the cells in automatically. My problem is the format of the date in the userform, i need: 10 August 2004, but it always comes up with ) 08/10/2004, the american format, i think.I have tried formatting the cell, but it doesn't do it automatically and it comes up with 08 October 2004 when you change it manually. Thanks for your help Is there a way of forcing excel to put the date in the desired format. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date
One way:
Dim rCell As Range For Each rCell In Range("DateRange") With rCell .Value = Date .NumberFormat = "dd mmmm yyyy" End With Next rCell In article , "Jon" wrote: Hi, sorry to bother you all with a mundane problem but my help file won't work and i can't get anything out of it. i've got a program which needs the date putting in very often. a userform pops up at the beginning to check that it has the correct date, and then fills all the cells in automatically. My problem is the format of the date in the userform, i need: 10 August 2004, but it always comes up with ) 08/10/2004, the american format, i think.I have tried formatting the cell, but it doesn't do it automatically and it comes up with 08 October 2004 when you change it manually. Thanks for your help Is there a way of forcing excel to put the date in the desired format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate including a date so that the date appears as a date | Excel Worksheet Functions | |||
date in Cell to change colors if the date is beyond today's date | Excel Discussion (Misc queries) | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |