Hi,

I print from Ln to the Excel primter defined normally to an .csv file. WhatI have experiemced it is that some fields having a numeric value (as 08000.00100) are cut because of the column type general in excel. They arrive in excel as 8000.001 and the others zeros are lost. For my report this is bad because these are item codes.
Has anyone an ideea what should i change?

Thanks

Hi baan_fun,

Could you write this data like this: "08000.00100"? It would keep the zeros that you're loosing, but is not very kindly...
Maybe another character would work to sinalize that the fild data is a string. I didn't try, but perhaps a TAB character.

Good luck!

Putting it in quotes just gets stripped off when entering Excel, and you loose the leading & trailing 0's again.

The best solution i found was this:

b.v.dj
Junior Member Join Date: Mar 2003
Location: Holland
Posts: 26


Baan: BaanIVc4 - DB: tbase - OS: Solaris
A simple solution for the leading zero's problem is to surround the field with

="<part_number>"

The =" will make Excel read the colum as text.


If you search for Excel .csv Leading 0 you will find a couple posts to review.

__________________
:) dirk


As found in the post: