I got a report that i exported into a txt file.
When I import it into Excel (2003), i a got an issue with numbers > 1000 ; Excel doesn't understand them as numbers but as text !!
Thus, it is difficult to use them...
I have to replace manually the thousand separator to complete the operation.
Is there a way to automate this operation ?
I try to import the same file on OpenOffice and it works fine !
But people are using Excel and doesn't want to use another application....
there is another problem with fields like Location ones, which contains more thant one line...
The generated file should contains DocNo / BPartner / GrandTotal / Location / Description.
I was expecting one line, i got 4 !!!!!!!
This looks like :
"DocumentNo" "Business Partner" "GrandTotal" "Address1
ZIP City" "Description(line1)
Any idea to manage this ?
Log in to post a comment.