How to create date format in vba

[Eric]

Hi there,

Can anyone help me please on how to create a date format
in this sample format, I want to write in macro that
automatically substitute them in my reports.

I want this format: "Tuesday, November, 25, 2003".

Can anybody help me please.

TIA
Eric

 

[Don Guillett]

try
Sub formatit()
' "Tuesday, November, 25, 2003".
Selection = Format(Selection, "dddd dd,yyyy")
End Sub

 

[Tom Ogilvy]

ActiveCell. NumberFormat = "dddd, mmmm, d, yyyy"

from the immediate window:

ActiveCell.Value = date
ActiveCell. NumberFormat = "dddd, mmmm, d, yyyy"
? activecell.Text
Tuesday, November, 25, 2003

 

[Christine Flott]

Eric,

If you go to Format-->Cells and choose a custom format, you can use
this to get that result:

dddd, mmmm, d, yyyy

You can then apply that format to the other cells in your spreadsheet
that contain dates.

Hope this helps.
Christine Flott