Where do I find Excel Report Generation parameters for number_format?

[henry]

In the Report Generation toolkit the "Excel Set Cell Format.vi" has a string input parameter for "Number Format". LabVIEW does not show any values for this input, just vaguely says check Excel documentation. In Excel itself, I can change the number format to "Text". In LV I have tried inputs of numbers 0 through 10, text, "Text", number_format.text, none of which work.

[Joe_Guo]

I believe the "Excel Set Cell Format.vi" is used for setting numerical format. For example, if you want to show only two decimal places then use "0.00".

-Joe

[henry]

You can also make numerical format as Text which is what I am trying to do. I am trying to enter 1-15 as Text and excel is changing it to a date or a number. LabVIEW has no indication how to enter make the cell see the value as Text.

[Joe_Guo]

See if string constant "@" (without quotes) works.

-Joe

[henry]

Congratulations, that did it. Thanks!