View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] deepak.us7@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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