Date formatting

[lordfa9]

In my company, the dates used in our system generated reports usually come out in the format ddmmyyyy, if the first number is a 0 it'll be omitted

So 11 June 2014 will appear as 11062014 and 01 Oct 2014 will appear as 1102014

Is there any way I can get excel to recognize these dates as is? Perhaps through format cell? I don't want to have to manually change them everytime

[:) Sixthsense :)]

In A1 Cell

1102014

In B1 Cell - Text Result

=TEXT(TEXT(A1,"00-00-0000"),"DD-MMM-YYYY")

Or

Converts A1 data to real date's

=VALUE(TEXT(A1,"00-00-0000"))

[lordfa9]

In A1 Cell

1102014

In B1 Cell - Text Result

=TEXT(TEXT(A1,"00-00-0000"),"DD-MMM-YYYY")

Or

Converts A1 data to real date's

=VALUE(TEXT(A1,"00-00-0000"))

got the first one to work; just for knowledge, whats the difference between the 2?

[:) Sixthsense :)]

Text() is a Text Function which result Text Result instead of real data.

First one will result text date in which you cannot format it using cell formatting option. Using formula's with the text data will not recognize it as real date, since it is a text result.

But the second one will result real date which is the suggestible way of having data and can be formatted using Cell formatting. Formula's can easily work with this data since it is Real date.