none
Text format when exporting to Excel RRS feed

  • Question

  • When I export a report to Excel all fields with digits is formatted as text.

    You can then mark all fields formatted as text, right click and in the menu convert them til digits, BUT

    My report is "Sales of  all products distributed on months" and sometimes a product is not sold in a month and then this particular cell is not formatted - and with such cells all over the report is is a bit hard to "convert to digits" because you CAN NOT just mark, right click and then convert, because of the cells with no "digits" in them.

    What is the solution ....

    can the report be exported WITHOUT this text formatting of cells with digits ?

    or can it be done in another way ?

    Thursday, October 30, 2008 7:17 AM

All replies