Dataport in Excel format

Kau_147 · 2012-01-02

When I run the dataport, the data will be posted in Excel file...
In that there is an Bank Account No. which is not printing in proper format.

i.e. The Account No. is '2400330001001'
But it is showing as '2.4E+12'

I tried to format that Bank Account No. as Format(bankAccNo,1) but its still printing the same.
Please help!!

mohana_cse06 · 2012-01-02

Did you search the forum?

Kau_147 · 2012-01-02

Yes !!!!
But thats not match with my query!!!

Cem_Karaer · 2012-01-02

Kau_147 wrote:

When I run the dataport, the data will be posted in Excel file...

A dataport cannot post any data to an Excel file. What do you mean with that?

Sog · 2012-01-02

Open the Excel file
Select the column with the Bank Acc. No. in.
Move your cursor the edge of the columns left/right border, until the cursor appears as "<-|->".
Doubleclick and you see the column taking the width of the largest value.
Your 2.4E+12 should appear as your full Bank Account Number.

Now, Excel is a different software solution than NAV. Because of this, format in NAV will not have ANY effect in Excel.
Not even if you specify decimal places and ...
This is because Excel parses every value against it's own logic.
And a number will usually be treated as a number.
If you want to force Excel to recognise your number as an Bank Account number (aka string) then put ' (single quote) in front of the value.
Always mind where one program stops and the other starts when transmitting data between programs.

For future refernce, please use the correct terms for better help:
A dataport creates a file that may or may not be readable by Excel. But it does not need Excel.
A report using the Excel buffer, does use Excel.

And to everybody, I wish a you all a wonderfull 2012!

Dataport in Excel format

Comments

Categories