View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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?