Excel Pivot table date formating

I am bringing data from SQL SERVER as data source in my Excel 2010. One of Column on my Data_Source Worksheet is named  Fiscal_Quarter. This column has values Quarter1,Quarter2,Quarter3,Quarter4.
I am going to create pivot table from this source data.
I want to see in my pivot table those values not as Quarter1,Quarter2….but as Qrt1,Qrt2,Qrt3,Qrt4.
How to do this.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
The easiest solution which i can tell you to do this is select your raw data where you have quarter.. and in their

press ctrl+H which will open the replace option...

replace what-->Quarter
Replace with-->Qrt

Hit replace all and their you go you will be set as your values will be changed and you can show them accordingly in the pivot table easily...


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ProfessorJimJamMicrosoft Excel ExpertCommented:
you can actually edit them in the pivot table. without changing the huge source data

once you created the pivot table,  select the cell with Quarter and press F2 in keyboard and it goes to edit mode and then change it to Qrt
TarasAuthor Commented:
Thanks a lot
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.