I had a similar problem i.e. numbers with prefix ' causing the column to be left aligned

cell.HasFormula for such cells returns FALSE. Therefore, although cell.Value does remove the ', it is never executed.
Did I miss something? I am using Win2000 & Excel 2000