datevalue to date

[bee123]

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

 

[deepakbathla]

Hello.....bee123...

firstly you copy datevalue 41062 as u have shown this & paste it excel sheet, after that...go to format cells....,select date format as you want.

 

[kuldeepjainesl]

Hi Bee123,


You can just change the formatting from general to date and you will get 2-6-2012.


To get in your desired format just use custom format as mm-dd-yyyy;@ and you will get 06-02-2012


Regards,

Kuldeep

 

[Faseeh]

Hi bee,


Do you want to place just a Zero before 2 i.e. 02 instead of 2?? Try this one:

=TEXT(CONCATENATE(DAY(A1),"-",MONTH(A1),"-",YEAR(A1)),"DD-MM-YYYY")

Regards,

Faseeh