Date Conversion

[Alakh]

Hi All,

I have a problem which I am not able to figure it out how to solve it. Whenever i download a data the date format comes into "Nov 06, 2011 11:45 PM" which I am not able to change into dd/mm/yyyy hh:mm:ss format.

Please help

Thanks

Alakh

 

[anandvarma]

first look at the data is it number or not, if it is a number apply custom number format
dd/mm/yyyy hh:mm:ss

if it not number they you have to use functions convert it in number ex:
if the data in cell a1 use formulas =a1+0 to convert that into number

 

[Alakh]

Hi Anand,

Thanks for replying.

See the problem is when someone else download the same data from same source and convert it through custom change and send it me I get in right format. But same thing I am not able to do that when I download myself.

Thanks
Alakh