Excel Formatting and sorting dates
Closed
blackdog11
Posts
1
Registration date
Sunday April 26, 2009
Status
Member
Last seen
April 27, 2009
-
Apr 27, 2009 at 01:54 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 28, 2009 at 03:46 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 28, 2009 at 03:46 AM
Hello,
Problem....
I'm entering dates into Excel. I need these dates date in the format "ddmmyyyy" with leading zeroes where the day is < 10 e.g. Fifth of August 2009 will display as "05082009"
When I type the string "05082009", it changes it to "5082009"
If I format the cell as a custom format of "00000000" to attempt this, I lose the date format and the columns sort as strings, not dates.
...I hope you'll help me
Problem....
I'm entering dates into Excel. I need these dates date in the format "ddmmyyyy" with leading zeroes where the day is < 10 e.g. Fifth of August 2009 will display as "05082009"
When I type the string "05082009", it changes it to "5082009"
If I format the cell as a custom format of "00000000" to attempt this, I lose the date format and the columns sort as strings, not dates.
...I hope you'll help me
Related:
- Excel Formatting and sorting dates
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to clear formatting in excel - Guide
- Number to words in excel - Guide
1 response
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
166
Apr 28, 2009 at 03:46 AM
Apr 28, 2009 at 03:46 AM
Its working fine. u must enter date format as ddmmyyyy AND when you will enter 5-8-09 it will automatically convert it as 05082009.
check date format of relevant cell .....
check date format of relevant cell .....