2 Replies Latest reply on Feb 1, 2007 3:20 PM by Rouset

    Export to Excel - strange data conversion

      I have a page in CF that exports data to CF. The page is setup as a table. I am having a STRANGE problem with numbers getting converted to characters.
      The data file itself contains the data as follows: <td style='mso-number-format:"\@"'>+973-39573722</td> ,
      However, when I open the file in Excel, it displays it as: 39573722

      and <td style='mso-number-format:"\@"'>973-17713979</td> as : 973-17713979

      For some reason it does not like the + in front of +973, eventhough I have formatted the field as a text field. Any idea???