As I am entering the date format dd/m/yyyy. The output is coming in the form of a number.
For example.. as I am inputting the date as 10/8/2008, the output that I am getting is 39729. Can you please help me out in this?

As I am inputting the date in the format of dd/m/yyyy. The output that I am getting is a number. Like I am inputting 10/8/2008, the output that I am receiving is 39729. Help me in getting the date that I want to input

The numeric conversion is automatic and required for Excel to be able to properly deal with DATE strings. The problem is that you're SEEING the conversion, it should not be evident.

1) Highlight the cell(s) in question
2) Press CTRL-1 to open the Format Cell window
3) Under Category: select Date
4) Under Type: choose the date format you want to display, there are many