Convert Number into Date

[HB07]

Hi..I am working on an excel file..which is referring to the cell in different spreadsheet. That cell contains date. But when i am pulling the cell entry.it is coming in the form of number 40179. I want to get the date in DD-MM-YYYY format or DD-Month-Year format. I dont want to use the format cells method. Please suggest the function

[shukla.ankur281190]

USe formula

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

[samba_ravi]

Select the Cells and Press Shift+Ctrl+3/# keys

[HB07]

what should be the formula if i want to get DD-Month-Year??

[samba_ravi]

=TEXT(A1,"DD-MMMM-YYYY")
Edit Cell Reference A1 according to your needs