excel to csv, some content turns to be "######" in csv

[blackhorse]

I have an excel document, when I save it in csv, some of the huge data turns out to be "############" in csv doc.

But for other excel documents, when I save them in csv, these huge data cell converted fine in csv.

Any advices?

Could that be this excel document is broken? (This excel docuement breaks every time when I open it in open office, but it is ok when I open it in the Microsoft Excel, but other excel documents I can open both in open office and in Micorsoft Excel, so there is something wrong with this excel, but I am not sure if that is the reason some content turned to be "############" when save as csv.)

Thanks

[ixalmida]

If it is a numeric field then you just need to expand the column in Excel because Excel just displays numeric fields as number signs when the column isn't wide enough to display the data.

Just to prove this theory, you can open your CSV in Notepad instead of Excel and see if there are any number signs. I'm betting there aren't.