MATLAB: Changing Cell Format for Excel using MATLAB

exporting to excel

How do I change cell format of Excel cells to Scientific which I need to plot. I use ActiveX Control as following Commands.
set(Excel.Selection.Font,'ColorIndex',7);
set(Excel.Selection,'HorizontalAlignment',3);
set(Excel.Selection.Interior,'ColorIndex',4); 
set(Excel.Selection.Font,'Size',13);
set(Excel.Selection.Font,'bold',1);
if I use set(Excel.Selection.Format,'Scientific');
MatLab or excel does not support. pls help
"Thanks in advance"

Best Answer

It appears to me that you should be setting NumberFormat instead of Format. What you should set it to depends on the details of the display you want.
See http://pubs.logicalexpressions.com/pub0009/lpmarticle.asp?id=414
Related Question