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
However, when I open the file in Excel, it displays it as:
style='mso-number-format:"\@"'>973-17713979</td> as :
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 for the suggestion. I had tried that idea before, too.
The apostrophe ends up showing in the cell in front of the value of
the field, when it is coded in the Cold fusion page. So, I need a
different way of fixing this problem.