| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create date format in vba
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create date format in vba
try
Sub formatit() ' "Tuesday, November, 25, 2003". Selection = Format(Selection, "dddd dd,yyyy") End Sub -- Don Guillett SalesAid Software "Eric" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create date format in vba
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 -- Regards, Tom Ogilvy "Eric" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to create date format in vba
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 "Eric" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a date format | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| how do I create a Date field format for mm/dd/yyyy (10 digits) | Excel Worksheet Functions | |||
| how to create conditional format linked to date | Excel Discussion (Misc queries) | |||
| Change a date in text format xx.xx.20xx to a recognised date format | Excel Programming | |||
![Eric[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
