Re : number formatting in Excel File

[KastillioNew]

Hi,

in my VI, I have an array of float numbers.. When I import this array in an Excel report.. the format of my numbers changes

example: 2236 becomes 2.236.000 or 11,38 becomes 11.180. It seems that the numbers in the form 0,xxx are recognized as strings and the other are recognized as numbers (see attached picture)..

How can I solve that?

Thank you

[Norbert_B]

---

@KastillioNew wrote:

[..]When I import this array in an Excel report[..]

---

Are you using the Office Report Generation toolkit?

I am recalling that there is a bug present in Excel which makes writing to Excel from external sources programmatically doing stuff like this. Sadly, i have no link available right now.....

Norbert

[KastillioNew]

Yes I use the toolkit...

[Norbert_B]

One thing you might want to check: It is possible that this issue might be created by the vile ','-'.' issue at localized OS. So please make sure that you change the regional settings to be "English(USA)" including the numeric format ('.' for decimal point, ',' for "thousands"). Time settings can, of course, remain in your local settings (whereever you come from....)

Norbert

[KastillioNew]

whre can I do this?

[Norbert_B]

This depends on the OS (Operating System). If you are using Windows, you should go to the control panel and select the regional settings there.

Norbert