date format change when exporting

[Wendy]

Hello, I have a pivot table in Excel that loads in info from an Access db
Table. On my Excel pivot, I have "Posting Date" as a field, and the
different dates populate from that table. However, the posting dates are
populting is in this format, "01-Oct" but I want it them to be in this format
"10/1/08."

On my table in access, the date format is what I want, the 10/1/08. When I
check the data properties for the Posting Date field, it says "Date/Time".
When I run the make table query, and the table refreshes, I get the format I
want on the table. How come when I link this Excel pivot to it, it changes
the date format, and what can I do to fix that?

Looking forward to hearing back from someone!
Wendy

 

[Wendy]

I should add that I posed this question in the Excel forum, but nobody
answered. Any suggestions would be most greatly appreciated!!

 

[Fred]

Maybe you'll get a more complete answer from someone smarter than me, but you
should know that in access date/time fields, you are looking at the DISPLAY
format for that item. The "format" for the actual contents is always the
same and is generally never seen.

My guess would be that the DISPLAY format either didn't ravel with the data,
or else a default display format in Excel took control.