View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rakesh[_2_] Rakesh[_2_] is offline
external usenet poster
 
Posts: 2
Default Excel Sheet cell format

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,