Excel Formatting and sorting dates

[Closed]
Report
Posts
1
Registration date
Sunday April 26, 2009
Status
Member
Last seen
April 27, 2009
-
Posts
190
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
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
155
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 2821 users have said thank you to us this month