when we go for baan2excel reports ...
the output in some other columns get truncated due to some excel std problems.

for e.g it converts to exponential format
how can v avoid it to do that???
with the help of single v can do it but it displays that single code...



DO ANY1 HAVE ANSWER FOR THIS...???

When you tranfer Baan reports to Excel and use the "Text to Columns" functionallity you have an option "Advanced" the select you decimal sign. Is this whay you're looking for?

i didnt get u
actually i found it when i opened textfile with excel using delimited option and pipe separator

If I understand you well, you are referring to automatic formatting of numbers, dates etc. If you want to prevent those, you either have to open the file usign an editor different than Excel, OR in your program/report script, you shall fix the values as strings.

Example:
Instead of 02569.5698 you send
='02569.5698'


Regards,
Eli Nager