Nora -
Mar 30, 2016 at 07:02 AM - Latest reply: vcoolio1159
Posts Thursday July 24, 2014Registration dateModeratorStatus
March 28, 2018
Last seen
- Mar 31, 2016 at 05:26 AM
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?
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.
