Exporting to excel, somehow transfers values into a date format?

HCL Domino Domino Forum
1

I’m trying to export about 10,000 rows from a view into excel except if I use a wk4 format, it only does the first 8192 lines.

If I export it as a CSV file, it transfers three quarters of the values of one column into a date format?

An example are the following:

03/1698 (exports fine)

03/1094 (exports fine)

03/1995 (became Mar-1995)

I can obviously see why it happens, but is there any way to stop it from happening?

Thanks in advance,

Katherine

2

Subject: Exporting to excel, somehow transfers values into a date format?

Hi, Kathetine.If you want to export these rows directly to *.xls file, I can help you. I have a nice LotusScript for this.

Contact me.

Good Luck.

3

Subject: Export them with an apostroph in front of like '09/1999

4

Subject: Exporting to excel, somehow transfers values into a date format?

I do my exports to Excel using COM. This way you can explicitly format your cells before / after the data goes in them. Is that an option for you?

–