Blank the integer data type

mrigya

Hi All
Please tell me how can i blank the integer type of variable,as its only taking '0' by default..can i make its just blank.
Thanks and Regards
Mrigya

sendoh

Do you try to expand the Columns of excel?, this is just the excel behavior when the Value in the Cell is too long for the Column.

tro#1

In Excel:
Right mouse click on the number (or column).

Choose: "Format cells..."

Tab: Number
Choose:
Category = Number and
Decimal places = 0

Click OK and you will see the number correctly.

Sandeep_Prajapati

Namaste Ji,

format the cell by

   XlRange.NumberFormat('0');

I hope it helps .... O:)

Sandeep_Prajapati

something like this.....

   XlSheet.Range('F'+FORMAT(j)).NumberFormat('0');

Xypher

If you're not inserting any functions and doing all calculations prior to the export I would just do the following...

ExcelApp.ActiveCell.EntireColumn.EntireRow.NumberFormat := '@';

(Sets the formatting of everything to: Text)


And to remove the Number as Text or Date as Text "warnings"...

ExcelApp.ErrorCheckingOptions.NumberAsText := FALSE;
ExcelApp.ErrorCheckingOptions.TextDate     := FALSE;

After that you can export anything you want and not have to worry how it might be interpreted by Excel.