How to create date format in vba

  • Thread starter Thread starter Eric
  • Start date Start date
E

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
 
try
Sub formatit()
' "Tuesday, November, 25, 2003".
Selection = Format(Selection, "dddd dd,yyyy")
End Sub
 
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
 
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
 
Back
Top