How do I get my date to look like this in Excel (Monday June 19,.
 

I need to display both the Day in text and the date in serial numbers. How do
I do that?

How do I get my date to look like this in Excel (Monday June 19,.
 

I hope you don't mean serial numbers (!) - format, cells

set the format to custom as

dddd mmm dd yyyy

Belinda wrote:
I need to display both the Day in text and the date in serial numbers. How do
I do that?

How do I get my date to look like this in Excel (Monday June 19,.
 

or use the same code in the text function, e.g:

TEXT(A1,"Dddd Mmm dd yyyy")


wrote:
I hope you don't mean serial numbers (!) - format, cells

set the format to custom as

dddd mmm dd yyyy

Belinda wrote:
I need to display both the Day in text and the date in serial numbers. How do
I do that?

How do I get my date to look like this in Excel (Monday June 19,.
 

Right-click on the cell with the date, then FormatCells NumberTab Custom
and in the Type: window, dddd m/d/yyyy ok

Vaya con Dios,
Chuck, CABGx3




"Belinda" wrote:

I need to display both the Day in text and the date in serial numbers. How do
I do that?