Format dates again
 

Hi
If i have 01-01-2006 i want to make my format like

1 January 2006

How do i do this?

Alvin

Format dates again
 

Hi Alvin

You need to create a custom number via Format\Cells

enter the following - d mmmm yyy


--
BadgerMK
------------------------------------------------------------------------
BadgerMK's Profile: http://www.excelforum.com/member.php...o&userid=31406
View this thread: http://www.excelforum.com/showthread...hreadid=511048

Format dates again
 

s = formt(cdate("01-01-2006),"d mmmm yyyy")

or if a cell
Activecell.Numberformat = "d mmmm yyyy")

--
Regards,
Tom Ogilvy

"alvin Kuiper" wrote in message
...
Hi
If i have 01-01-2006 i want to make my format like

1 January 2006

How do i do this?

Alvin

Format dates again
 

Thanks

Alvin


"BadgerMK" wrote:


Hi Alvin

You need to create a custom number via Format\Cells

enter the following - d mmmm yyy


--
BadgerMK
------------------------------------------------------------------------
BadgerMK's Profile: http://www.excelforum.com/member.php...o&userid=31406
View this thread: http://www.excelforum.com/showthread...hreadid=511048