Multifunction DAQ

cancel
Showing results for 
Search instead for 
Did you mean: 

Report-generation with Excel97 (german-version)

When I send values to excel97 (german) using "excel easy table.vi" (numeric or string format) or "Append Numeric Table to Report.vi" the values are not represented as numbers but as text. Only after double-click on the cell (same as additional enter) excel automatically takes it as a number. (Not possible/stupid with large number of values.)
How can I make excel dirctly accept my values?
0 Kudos
Message 1 of 3
(2,373 Views)
How can you tell if the number you see in excel is being interpreted as a string or a number?
0 Kudos
Message 2 of 3
(2,373 Views)
Sorry, been on Holiday...

The number is aligned left in the excel cell and ignored in further calculations. (See the attached example).
Meanwhile I found some "trick": I run an excel-macro to reformat all cells (should be included in the example-file).
But is this the right way (takes time), or is it possible to make excel directly accept the values?

Thanks for your interest,
Till
0 Kudos
Message 3 of 3
(2,373 Views)