Report

Dates written in different ways [Solved]

Ask a question Nora - Last answered on Mar 31, 2016 05:26AM
Hello,

I have a spreadsheet with dates written in different ways. August 2010 is written both August-10 and August 2010. How can I change this so that the date is written in the same way for all of the observations?

Thank you for your time.
See more 
Helpful
+0
moins plus
Hello Nora,

Right click the cells (or entire columns) that have dates in them. From the menu that appears, select Format Cells. In the Format Cells window that appears, select Custom and in the type box, type in the following:-

mmmm, yyyy

then click OK. In the formatted cell (or cells), if you type in, for example, 8/2010 the result will be August, 2010.

This gives you an idea of what can be done, so experiment with it in a blank sheet and change the formatting to suit yourself.

I hope that this helps.

Cheerio,
vcoolio.
Nora- Mar 31, 2016 05:01AM
Thank you!
Reply
Add comment
Helpful
+0
moins plus
Hello Nora,

You're welcome. I'm glad that I could help.

Cheerio,
vcoolio.
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!