software

Format the cell as General.

niamh wrote:

--

Dave Peterson

The reformat to general works within the spreadsheet, but if it is necessary
to export to a csv file using the text format, the ### shows up in the file
when opened in WORD. Does anyone know how to actually fix the problem? Or
what causes it?

quot;Dave Petersonquot; wrote:

gt; Format the cell as General.
gt;
gt; niamh wrote:
gt;
gt; --

gt; Dave Peterson
gt;

Before I'd venture a guess, I'd want to know how long the string is and how you
created the .csv file.

And if you open that .csv file using NotePad, do you still see the same problem?

And the version of excel/word that you're using.
cd wrote:
gt;
gt; The reformat to general works within the spreadsheet, but if it is necessary
gt; to export to a csv file using the text format, the ### shows up in the file
gt; when opened in WORD. Does anyone know how to actually fix the problem? Or
gt; what causes it?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Format the cell as General.
gt; gt;
gt; gt; niamh wrote:
gt; gt;
gt; gt; --
gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson