Setting in MS Excel

[Anu Sharma]

I am using MS Excel 2007 and for some reasons due to a plugin or a setting, I am not able to format dates.

Can someone please throw some light on it?

If I select - right click - Format cell - Date - mm-ddd-yy, only few get changes not the rest

What can be done?

 

[Deepak]

Its not a date issue, you are going to format mm-dd-yy where those have day>12 will not accept this. Try text to columns & select correct date format. Would u pls share the raw file without any additional formatting by u....

 

[vletm]

@Anu Sharma
Have You done those with 'Copy-Paste'?
Sorry! For some reason there is something in front of some 'dates'.
Manually version is that 'click' in front of every 'date' and click somewhere else.
Then those 'date' change formats as You want.
This takes times and ...
But better to try to copy-paste one more time!
as Deepak wrote just.

 

[Anu Sharma]

Its not a date issue, you are going to format mm-dd-yy where those have day>12 will not accept this. Try text to columns & select correct date format. Would u pls share the raw file without any additional formatting by u....