Blank the integer data type

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