| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Sheet cell format
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format Cell with Reference to another sheet | Excel Worksheet Functions | |||
| Carrying format with cell reference to another sheet. | Charts and Charting in Excel | |||
| how do I format the sheet so that I may click on 1 cell at a time | Excel Worksheet Functions | |||
| copy a formatted cell to another sheet as text without format | Excel Discussion (Misc queries) | |||
| How do I copy a print format from sheet to sheet in excel ? | Excel Discussion (Misc queries) | |||
Linear Mode
