Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |