Blank the integer data type

mrigya
mrigya Posts: 124
edited 2008-09-09 in NAV/Navision Classic Client
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

Comments

  • sendoh
    sendoh Posts: 207
    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.
    Sendoh
    be smart before being a clever.
  • tro#1
    tro#1 Posts: 122
    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
    Sandeep_Prajapati Posts: 151
    Namaste Ji,

    format the cell by 
       XlRange.NumberFormat('0');


    I hope it helps .... O:)
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
  • Sandeep_Prajapati
    Sandeep_Prajapati Posts: 151
    something like this..... 
       XlSheet.Range('F'+FORMAT(j)).NumberFormat('0');
    Sandeep Prajapati
    Technical Consultant, MS Dynamics NAV
  • Xypher
    Xypher Posts: 297
    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.

Categories