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
|