Forum Discussion
Solved
Excel convert text to year
I copied data from https://www.metoffice.gov.uk/hadobs/hadcet/cetml1659on.dat to an excel sheet To plot it I need to convert the first columns to year. Googled online, no clear answer. I tried seve...
- Thanks. Let me digest it for a day or two. It looks like excel has changed since the last version I used, that was from early 2000s. Thanks again
Seems to work. Thanks. I tired to "like" your answer but instead somehow marked my question as a solution. I have no idea what I did wrong. I guess I am too old for new technology. Again, thanks for your help.
Mike_Kova No problem. You must have marked it yourself. Perhaps accidentally, because your name is on it.
I believe only you can unmark it yourself. How, I don't know. Never done it. And liking is done by pressing on the thumbs-up icon, not by pressing on the word "Likes!.
Mike_Kova Don't really know what you are referring to. But perhaps you can just create a pivot table on the one column with dates. Drag the date to the row field (Excel should automatically group them by month). Then drag the date to value field and set it to count (not sum) and you'll end up with a table that counts the numbers of date items within a month.
- I am trying to post another question but somehow I can't so I figured maybe I ask you. I got a file from https://cneos.jpl.nasa.gov/fireballs/ , After removing all columns but the first one, I am left with just the first column with a list of dates of fireballs. How do I count how many fireballs were in each month? Thanks.