0 Replies Latest reply on Feb 1, 2007 4:41 AM 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???

      Thanks,
      Ros