$date='30-09-11'
$objPHPExcel->getActiveSheet()
->setCellValue(toAlphaNumber($tmpCOunt + 9) . $rowNbmr, $date)
->getStyle(toAlphaNumber($tmpCOunt + 9) . $rowNbmr )->applyFromArray( array( 'font' => array('color' => array('rgb' => '000000')) ))
->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14 )
;
on Excel the cell shows that it is a "Date" but I can't manipulate it before I select the cell and press any key, then automatically it will align to the right and I become able to manipulate as a date.