Format date for days?

Tyler Durden · May 9th, 2002, 08:01 AM

Is it possible to format a cell to show the DAY after you type in the DATE? For example, if a user would type "5/9/02" the cell would then convert it to "Thursday, May 9, 2002" upon exit. It sounds simple and I know it can be done in Word, but can Excel do it?

Thanks,

Mudface · May 9th, 2002, 08:03 AM

Try formatting the cell as: -

dddd, mmmm, d yyyy

[ This Message was edited by: Mudface on 2002-05-09 07:04 ]

Tyler Durden · May 9th, 2002, 08:05 AM

Mudface-

I dig your name and your solution worked.

Thanks!

Mudface · May 9th, 2002, 08:06 AM

Thanks, Tyler, stll selling soap?

Tyler Durden · May 9th, 2002, 08:08 AM

It's rendering the fat that's the fun part...

Take care,
T

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:01 AM	#1
Tyler Durden New Member Join Date: Apr 2002 Location: USA Posts: 17	Is it possible to format a cell to show the DAY after you type in the DATE? For example, if a user would type "5/9/02" the cell would then convert it to "Thursday, May 9, 2002" upon exit. It sounds simple and I know it can be done in Word, but can Excel do it? Thanks,

May 9th, 2002, 08:03 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try formatting the cell as: - dddd, mmmm, d yyyy [ This Message was edited by: Mudface on 2002-05-09 07:04 ]

May 9th, 2002, 08:05 AM	#3
Tyler Durden New Member Join Date: Apr 2002 Location: USA Posts: 17	Mudface- I dig your name and your solution worked. Thanks!

May 9th, 2002, 08:06 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Thanks, Tyler, stll selling soap?

May 9th, 2002, 08:08 AM	#5
Tyler Durden New Member Join Date: Apr 2002 Location: USA Posts: 17	It's rendering the fat that's the fun part... Take care, T