Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel NUmber format IN VC++
Hi,
I wanted to Display a Text say it is "0011" in one particular cell so for this I use this range.SetNumberFormat(COleVariant("@")); range.SetItem(COleVariant((long)(1)),COleVariant(( long) (1)),COleVariant((LPCTSTR)csData)); but while it is put into the Excel.. it puts in the text as "0011". But now say i close the Excel and again i reopen the same file, that time the Text is displayed as "11" instaed of "0011" COuld any one please help me about this.... ITS URGENT |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel NUmber format IN VC++
Hi,
I'm not clear on what you are trying to do. Suppose you want to display a number as 0011. Just set the format for the custom number format of 0000. This format displays numbers to 4 digits with leading zeros where necessary. Note this is not a text format but a number format. You enter the custom code by choosing Format, Cells, Number tab, Custom, and typing 0000 into the Type line on the right. If you are trying to enter the numbers as text, not just format it as text then 1. Format the range as text first 2. Then enter the number. Both of these approaches could be recorded for use in code. -- Thanks, Shane Devenshire " wrote: Hi, I wanted to Display a Text say it is "0011" in one particular cell so for this I use this range.SetNumberFormat(COleVariant("@")); range.SetItem(COleVariant((long)(1)),COleVariant(( long) (1)),COleVariant((LPCTSTR)csData)); but while it is put into the Excel.. it puts in the text as "0011". But now say i close the Excel and again i reopen the same file, that time the Text is displayed as "11" instaed of "0011" COuld any one please help me about this.... ITS URGENT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is defaulting to Number format instead of General format | Excel Discussion (Misc queries) | |||
Excel number format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Number format based on number format of another cell in another workbook | Excel Programming | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |