Why Excel format column isn't respected at budget export ?

karimarzour

Hi everybody

I've exported from Navision 400 budget to excel using standard function.
Export is running but in Excel the format of the G/L account number is not respected.

I run Excel 2003 under XP Pro. When viewing the Excel worksheets the G/L account No column is considered as text. Even after formating cells as standard into Excel the import function doesn't recognize the G/L account No.
I've been to the windows settings but nothing better.

By the way when I run the analysis by dimension export to Excel function it works perfectly the format is fully kept.

Anybody any idea is welcome. :?: :?:

Thanks in advance

kine

If I understand correctly, problem are the leading zeros in G/L Account No?

karimarzour

This is the error message from excel when you pass the mouse on the cell
"The number in the cell is text format or preceeded by an apostrophe" wich is a cote '.

May be when the n avision report runs it creates a cote just in front of the G/L account number field. Someone can check the Report code programming

Thanks to examin