Excel Formatting and sorting dates [Closed]

Report
Posts
1
Registration date
Sunday April 26, 2009
Status
Member
Last seen
April 27, 2009
-
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
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

1 reply

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
215
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!