Posted to microsoft.public.excel.programming

Samantha

external usenet poster

Posts: 24

How do I change the dates?

I am working on a spreadsheet that the dates are inputted as 1/5/08 and
display as Jan-08. I am wondering how do I change all the dates that say
1/5/08 to how they are actually displayed? I need them for a Pivot table, as
of right now when i do a pivot table it comes up with like 5 Jan-08's and 10
different Feb-08's, when I want them to be one of each.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Change Dates	Aaron	Excel Programming	1	November 16th 06 11:19 PM
Dates That Change	Bob	Excel Worksheet Functions	1	November 3rd 06 09:49 PM
Dates change the next day.	TimM	Excel Worksheet Functions	6	January 1st 06 10:52 PM
How do I change dates from dd/mm/yy to mm/dd/yy	Dotteee	Setting up and Configuration of Excel	2	November 17th 05 02:02 PM
Excel dates change	Mags	Excel Worksheet Functions	1	November 11th 05 05:14 PM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us