Date format refresh revisited

Hello,

I have an interesting problem with Excel vba and change of cell formating. Consider the following example. Below there is a column over which the vba script rolls and changes the format from General to Date (dd/mmm/yyyy). As you see, although the script touches each cell, the change is not everywehere succesful. (01-Apr-2010 is succesful but 28/04/2009 21:00:11 is not).

In general I have observed that it is succesful in formatting a date with low day number.

Below the sample column there is my script that formats the date.

BTW I found on other forum that I have to add this special line that refreshes the cell:

Please Login or Register  to view this content.

but it clearly does not work. Any ideas??
Even more interesting is that if i click on a cell to bring the cursor, the format changes as it should. I've tried to record the macro what is beneth my hand-clicking and found that it actually is cl.FormulaR1C1 !!!

Sample Column
28/04/2009 21:00:11
01-Apr-2010
01-Mar-2011
28/04/2009 21:01:08
01-Aug-2010
01-May-2011
28/04/2009 21:11:00
18/02/2010 14:49:54
23/02/2011 12:30:32
28/04/2009 21:11:07
19/02/2010 13:35:31
18/02/2011
28/04/2009 21:11:12
22/02/2010 07:53:58
24/02/2011 09:12:10
28/04/2009 21:11:19
22/02/2010 08:13:05
24/02/2011 09:49:15
28/04/2009 21:11:25
22/02/2010 08:18:06
24/02/2011 15:40:55

Function formatting column:

Please Login or Register  to view this content.