Excel Date Format
Solved/Closed
moses
-
Aug 13, 2008 at 01:36 AM
zopfan Posts 7 Registration date Wednesday July 11, 2012 Status Member Last seen August 20, 2018 - Jan 13, 2014 at 06:59 AM
zopfan Posts 7 Registration date Wednesday July 11, 2012 Status Member Last seen August 20, 2018 - Jan 13, 2014 at 06:59 AM
Related:
- Excel Date Format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Marksheet format in excel - Guide
- Samsung format code - Guide
- Excel free download - Download - Spreadsheets
2 responses
Hi, select the complete cell right click and go to format cells select the date in the list select the format that u need....
First an important note: when typing a date into a cell you can't type it with dots like 12.1.2008 (Excel won't understand that as a date) but you have to type it with slashes: 12/1/2008
now for your question:
You can format the date in a cell as you desire by following the next steps:
1. Select the cell(s) containing the date(s).
2. Open the menu "format" and choose "cells".
3. On the list on the left choose "custom"
4. In the "type" text field you will see something like m/d/yyyy , delete it, and type the following instead: dd-mmm-yy
5. Click OK.
The key here is the dd-mmm-yy which sais to Excel: give me the day in two digits, the Month in a word, and the year in two digits.
Good luck!
https://www.free-training-tutorial.com/
.
now for your question:
You can format the date in a cell as you desire by following the next steps:
1. Select the cell(s) containing the date(s).
2. Open the menu "format" and choose "cells".
3. On the list on the left choose "custom"
4. In the "type" text field you will see something like m/d/yyyy , delete it, and type the following instead: dd-mmm-yy
5. Click OK.
The key here is the dd-mmm-yy which sais to Excel: give me the day in two digits, the Month in a word, and the year in two digits.
Good luck!
https://www.free-training-tutorial.com/
.
zopfan
Posts
7
Registration date
Wednesday July 11, 2012
Status
Member
Last seen
August 20, 2018
7
Jan 13, 2014 at 06:59 AM
Jan 13, 2014 at 06:59 AM
Hey, I was also a lot confused with a cell entry like this: 2.5.2014. Excel simply wasn't taking/accepting it as a date.
Then I read this post of your that excel won't recognize the digits with dots as a date (rather we have to type the digit inserting hyphens). Peculiar though. Are you positive that there is no way we can force the excel to accept these as dates?
Then I read this post of your that excel won't recognize the digits with dots as a date (rather we have to type the digit inserting hyphens). Peculiar though. Are you positive that there is no way we can force the excel to accept these as dates?
