Previous Topic Next Topic

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
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
Related:

1 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
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 .....
3

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses