Formating Issue.

[needhelp2]

Hello Guys,

My date format is not being change even i had try to change it from format option,not being change in general format as well.But no change seen kindly tell me how to do so?there are so many dates in sheet and i can't manually input them.I had already check it from paste special--value option.


Regards,
Smith.

 

[villy]

Check Control Panel | Regional and language settings of your date format..

 

[needhelp2]

Thanks Dear Villy for your Prompt response.

Format is correct there.its seems same as i had in excel. dd/mm/yyyy.

 

[villy]

Is there no any macro controlling your cells with dates?It might be sme code to format those dates as constant..Just thinking

 

[needhelp2]

K thanks for guide line.I hope now i can fix it up.Thanks alot..........