ExcelBanter - Excess text reverts to ######## , any way around this?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excess text reverts to ######## , any way around this? (https://www.excelbanter.com/excel-discussion-misc-queries/82892-excess-text-reverts-any-way-around.html)

Excess text reverts to ######## , any way around this?

Format the cell as General.

niamh wrote:

--

Dave Peterson

Excess text reverts to ######## , any way around this?

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?

"Dave Peterson" wrote:

Format the cell as General.

niamh wrote:

--

Dave Peterson

Excess text reverts to ######## , any way around this?

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:

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?

"Dave Peterson" wrote:

Format the cell as General.

niamh wrote:

--

Dave Peterson

--

Dave Peterson