Export to excel : loss of last 3 numbers???

vanrofi

Hi all,

When exporting to excel (same when using copy paste or the Export to Excel function in Nav50) a long number loses its 3 last digits and makes 000 of it.

I experienced this when exporting customer bank accounts where a number 00930434780044297230 becomes 9,30435E+17
and when I change the format it is 00930434780044297000

Pretty ugly in this case...maybe a setting in Excel, but as I experience this in Nav, it is not misplaced in Mibuso.

Thx for any info on this

vanrofi

Export to word does not convert this to number and gives no problem.
When I copy the value from word to excel again it reconverts in a bad way...so yes : not really nav issue...

Anyone found solution for this?

David_Singleton

I think you will find that Bank account numbers are NOT decimals, in fact they are alpha numeric, but just happen to only use the 10 digits characters.
So just format the cell as text before you paste and it should work fine.

vanrofi

Yes, that works...quite obvious but well sometimes you just don't see it.

I was already in this stage...
http://forums.cnet.com/5208-6129_102-0. ... dID=292538

but your workaround works and your answer was much shorter ;-)

Hope you enjoyed your stay in Belgium.

David_Singleton

vanrofi wrote:

Yes, that works...quite obvious but well sometimes you just don't see it.

I was already in this stage...
http://forums.cnet.com/5208-6129_102-0. ... dID=292538

but your workaround works and your answer was much shorter ;-)

Hope you enjoyed your stay in Belgium.

Old proverb "Man with hammer sees all problems as a nail". Those guys look like programmers lookign for a coding solution to a business issue.

What I normally do is

• copy the rows
• Paste to excel
• Format the text columns correctly
• re-paste the values only into the correctly formatted Excel sheet.