LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
mj mj is offline
external usenet poster
 
Posts: 78
Default Dates and days of the week

In cell B3 it reads Wednesday, December 31, 2008 but if I put my cursor in
the cell it shows only 12/31/2008 as the contents. I want a pivot table that
shows day of the week as well as date. With this formatting it only shows
the date not the day of the week. I have tried formatting as date, text, and
general and cannot get the info showing to really be what Excel thinks is in
the cell.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert regular Date to Week Ending or Week Beginning Dates Sam H Excel Discussion (Misc queries) 5 April 3rd 23 04:39 PM
How to get days of week by entering dates? jspaeth Excel Discussion (Misc queries) 4 August 19th 08 06:15 PM
Re Change 5 week days to 7 days in this formula pano Excel Worksheet Functions 7 February 1st 07 04:20 PM
Applying days of the week to dates will Excel Discussion (Misc queries) 1 December 5th 05 03:34 PM
Sorting Dates in Days of the Week Eagle784 Excel Discussion (Misc queries) 3 August 19th 05 05:31 PM


All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"