Hello!
I'm trouble with MS-Excel. I'm trying to export a excel file to a csv
file, but in my cells I have many caracters. In Excel these cells are
shown with #####, but I can see the right content in the Formula Bar.

When I export all data to CSV, the data inside the large cells are
replaced by ##### and I lose the original content.

Someone can help me, please?
Thanks in advance.


--
marcelomogi
------------------------------------------------------------------------
marcelomogi's Profile: http://www.excelforum.com/member.php...o&userid=37352
View this thread: http://www.excelforum.com/showthread...hreadid=570504

You're seeing ###### in the cells because the cells are not large
enough to display the data, change the cell column width's and row
heights as necessary to view the data, then try exporting it to CSV.
Easiest way would be to select all cells, then format - row- autofit,
format - column- autofit

Excel has a problem with cells that contain strings with text length between 255
and1024 characters and shows the ### signs.

Format the cell(s) to General and should go away.


Gord Dibben MS Excel MVP

On Thu, 10 Aug 2006 15:56:16 -0400, marcelomogi
wrote:


Hello!
I'm trouble with MS-Excel. I'm trying to export a excel file to a csv
file, but in my cells I have many caracters. In Excel these cells are
shown with #####, but I can see the right content in the Formula Bar.

When I export all data to CSV, the data inside the large cells are
replaced by ##### and I lose the original content.

Someone can help me, please?
Thanks in advance.

Gord Dibben MS Excel MVP