Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Month format not working

Posted on 2014-04-22
3
Medium Priority
?
157 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:
Naresh Patel earned 1000 total points
ID: 40015443
See attached use =TEXT(A2,"MMM-YY") & Formula Drop down.

Thanks
Month.xlsx
0
 
LVL 35

Assisted Solution

by:Norie
Norie earned 1000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
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…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

885 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