Rakesh,
Record a macro in Excel of your actions, then convert to C++.

NickHK

"Rakesh" wrote in message
...
Hi All,

I need help.
I am creating Excel files using VC++ MFC programming and for that I have
used MS Office type library.

Problem occurs when a large number($124,121.50) written in any cell of
excel
sheet.
If i open the file Excel shows it as #########. Number is stored but not
shown in correct form. If I increase the width of the cell Excel shows the
number correctly.

I want if any one know how I can programmatically set the auto width of
the
cell according to its number width?

Plz reply as soon as possible.

Best Regards,