NAV 5.0 Exporting to Excel, number's format

[Eva]

Hello

I'm using Nav 5.0 SP1 and when export data to Excel (data in a form, for
instance) I get then all then numbers in text format. I've to change all to
number format to allow operations.

Looking for it in the group, I founded this link:

http://blogs.msdn.com/nav_developer/archive/2008/11/11/dynamics-nav-5-0-sp1-and-export-to-excel.aspx

It tell us: "To implement correction, update with 5.0 SP1, update 1 (KB
956161, build 27191), use default style sheets included in SP1, and make the
following change to default style sheet NavisionExportToExcel.xslt"

I can't find this file NavisionExportToExcel.xslt, any idea where it can be?

TIA

Eva.

[Luc Van Dyck]

Post by Eva
I can't find this file NavisionExportToExcel.xslt, any idea where it can be?

I presume it's a typo in the blog, and that they are meaning the file
NavisionFormToExcel.xslt, which resides in the Stylesheet folder (in the NAV
client folder).

Luc Van Dyck
webmaster http://mibuso.com
14 May 2009 - Join the http://www.mibusoconference.com

[Eva]

Hello Luc

Yes, I realized in a second reading

But, I did what the article say and didn't feel any diference in my export
to excel, the numbers are in text format. ¿Can you help me?

Thanks

Post by Luc Van Dyck

Post by Eva
I can't find this file NavisionExportToExcel.xslt, any idea where it can be?

I presume it's a typo in the blog, and that they are meaning the file
NavisionFormToExcel.xslt, which resides in the Stylesheet folder (in the NAV
client folder).
Luc Van Dyck
webmaster http://mibuso.com
14 May 2009 - Join the http://www.mibusoconference.com

[Luc Van Dyck]

Post by Eva
But, I did what the article say and didn't feel any diference in my export
to excel, the numbers are in text format. ¿Can you help me?

Sorry, can't help you on this one. I haven't applied the KB-article myself.

[Eva]

Thanks Luc, I'll write another post with this topic.

Post by Luc Van Dyck

Post by Eva
But, I did what the article say and didn't feel any diference in my export
to excel, the numbers are in text format. ¿Can you help me?

Sorry, can't help you on this one. I haven't applied the KB-article myself.