Excel to CSV problem

  • Thread starter Thread starter marcelomogi
  • Start date Start date
M

marcelomogi

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.
 
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

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.
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top