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

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