Re: Dates in Pivot Table out of sequence - help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Thanks for the tip, but that didn't work.

I am sure it is really a date because when I re-format the column to
different date formats (mm/dd, mm/dd/yyyy, etc) all the values change,
the 5/8 date included. Nonetheless I tried deleting it and re-entering
it, then refreshing, that still didnt help. Next I grabbed the date
above it (5/7) dragged it down one cell to turn to 5/8, then
copy/pasted that through the rows that should be 5/8. Not even that
worked.

Any other suggestions?


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7092
View this thread: http://www.excelforum.com/showthread.php?threadid=542995

.

Relevant Pages

  • Re: Recently Added in WMP11 - more observations
    ... Now that sounds like a serious flaw in the coding of Windows Media Player that it cannot handle local date formats for the customer's PC. ... If you go to the Regional and Language Options control panel: Customize: ... Date options and change the Short Form to MM/DD/YYYY, ...
    (microsoft.public.windowsmedia.player)
  • Re: format(EnterDate, "mm/dd/yyyy")
    ... Douglas J. Steele wrote: ... ignorant of other date formats than mm/dd/yyyy. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Format Question
    ... Tom Phoenix wrote: ... MM/DD/YYYY 2:00 ... But the simplest way of all may be to avoid using formats. ... Stonehenge Perl Training ...
    (perl.beginners)
  • Re: Saving MS Project File in Excel maintaining format
    ... For the indentations, see: http://masamiki.com/project/macros.htm ... As for Formats, I suggest you use Excel's filters to allow you to re-format in bulk. ...
    (microsoft.public.project)
  • Re: Format Question
    ... MM/DD/YYYY 2:00 ... of the logical descending order of YYYY/MM/DD?) ... When you refill the two _copy variables, they'll be consumed on the next write. ... But the simplest way of all may be to avoid using formats. ...
    (perl.beginners)