Multilne comment in an excel cell

[Icemokka]

Hi,

I've made an app in VB6 that allows export to excel.
Everything works fine except for some multiline texts, he only
displays ############ instead of the full text.

I've also tried to correct the problem in the excelsheet itself to see
what I need to change in my export-code.
But even in excell I don't get the cell correctly filled in.

For what reasons does excel display ###### instead of the multiline
text ( cell formatiing is text )?

PS : I can provide the problem excel by mail ...

Regards,
Sven Peeters

 

[Dave Peterson]

Try formatting the cell as General--not Text.

Hi,

I've made an app in VB6 that allows export to excel.
Everything works fine except for some multiline texts, he only
displays ############ instead of the full text.

I've also tried to correct the problem in the excelsheet itself to see
what I need to change in my export-code.
But even in excell I don't get the cell correctly filled in.

For what reasons does excel display ###### instead of the multiline
text ( cell formatiing is text )?

PS : I can provide the problem excel by mail ...

Regards,
Sven Peeters

 

[Icemokka]

Try formatting the cell as General--not Text.

That worked, Thank you very much !!!!!!!!!!!!!!!!!!!!!!