Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Month format not working

Posted on 2014-04-22
3
149 Views
Last Modified: 2014-04-22
Is there an expert out this that can assist with this please.
I have attached a file wit the date in column 'A'

I want to convert this to mmm-yy in column 'B' so that it will produce a pivot as in the example

I have manually typed the date in column 'C' to demonstarte.
Month.xlsx
0
Comment
Question by:Jagwarman
3 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 40015442
Use the formula

=value(A2)
0
 
LVL 8

Accepted Solution

by:
itjockey earned 250 total points
ID: 40015443
See attached use =TEXT(A2,"MMM-YY") & Formula Drop down.

Thanks
Month.xlsx
0
 
LVL 33

Assisted Solution

by:Norie
Norie earned 250 total points
ID: 40015742
Select the data column, goto Data>Text to columns..., pick DMY as the column data format on step 3 and then click Finish.

Now you should have 'real' date values which you can group by year and month in the pivot table.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question