Dates written in different ways
Solved/Closed
Nora
-
Mar 30, 2016 at 07:02 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Mar 31, 2016 at 05:26 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Mar 31, 2016 at 05:26 AM
Related:
- Dates written in different ways
- Gamescom 2023 dates - Guide
- Defcon 2023 dates - Guide
- Nintendo direct 2023 dates - Guide
- Hi5 dating site sign in - Guide
- Steam sale dates - Guide
2 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Mar 30, 2016 at 09:30 PM
Mar 30, 2016 at 09:30 PM
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.
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.
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Mar 31, 2016 at 05:26 AM
Mar 31, 2016 at 05:26 AM
Hello Nora,
You're welcome. I'm glad that I could help.
Cheerio,
vcoolio.
You're welcome. I'm glad that I could help.
Cheerio,
vcoolio.
Mar 31, 2016 at 05:01 AM