View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How to display only the days of the week?

Format the cells with a custom number format like "dddd".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tom" wrote in message
.. .
I have a column of dates. How can I make it to display only the days of the
week, like Monday, Tuesday, ...... etc.?

TIA
Tom