I would like to convert a real number into a string, and write the string to a spreadsheet.

[matrix]

However, the way i am doing it, using the "number to decimal string function" rounds the real number to an integer, but i need a real value to be written to the file. Please advise?

[Gorka Larrea]

Use Fractional number to string instead of decimal, and READ THE LABVIEW HELP before you make a question.

[Joe_Guo]

even better, use "Format into string" VI.

Joe
Roush Industries, Inc

[Shan Pin Koh]

I would suggest using the Format Into String function as you would be able to convert the real number into a string and properly format the string before it is written to the spreadsheet.

My guess is that you would want to store several real numbers and have tabs in between the numbers. You'd probably want a carriage return also after each set of numbers. You can easily format the string by either using "Edit Format String" when you right click on the "Format Into String" function. Carriage return is \n and tab is \t. To format a real number with 12 precision points, it is "%.12f", etc.

Hope that helps.

P/S: If my guess is far off what you were looking for, then disregard it...


Shan Pin Koh
Systems Engineer
Oakriver Technology