convert datevalue to date?

[excelbee]

Can anyone help me to how to convert datevalue to date?
I have 41062 as datevalue, and I want to convert it to date as 02-06-2012.

when I use concatenate(day(A1);"-";month(A1);"-";year(A1))-> I got it as 2-6-2012.


But I want 02-06-2012.


How to get that? Pl help

 

[theBardd]

Just format the cell in a date format.

 

[excelbee]

its already in date format

 

[theBardd]

If it shows as 41602, it isn't in date format.

 

[vds1]

Try ,

=TEXT(A1,"DD-MM-YYYY")