digits of precision limit to 3 significant digits

[GerdW]

Hi Susanne,

no, changing the display format only changes the way the number is displayed.

It does NOT change the value!

[Susanne1709]

ok thanks.

In my VI it's working, but in the VI I needed it's not. I tested it with a probe, and the output is still 2 digits. The value is correct. What is the reason for that? Do you know?

[GerdW]

Hi Susanne,

the probe shows you values with 2 digits after decimal point.

And now? How is this related to your actual problem?

You need to set display format of each indicator. Setting display format of one indicator does NOT influence neither internal value nor other indicators!

[Susanne1709]

I actually set each indicator but the output is still the same - I don't care if it has 2 or 3 or 4 digits but my client wants 3. I will search why this happens.

[GerdW]

Hi Susanne,

please attach a real VI showing your problem.

Where do you want to have numbers with 3 digits?

- When it is an indicator: set its display format.

- When it is in a file: format the numbers correctly when writing the file…

[Susanne1709]

yes, I'm searching now in the creating report VI. I will search first, then ask if I can't cope with it. Thanks!

[Susanne1709]

I can't find the error why the value "Öl Periode Sensor" doesn't show 3 decimal places. First I thought it could be the database where all measurements are saved. So I changed the value from 2 to 3 decimal places (I didn't use zero numbers) in the database and created the Excel Sheet again but it shows still 2 decimal places. Also my colleague searched but didn't find anything. I have changed the display format of all values I found but it's still not working. Have anyone an idea what I need to change to get 3 instead of 2 decimal places? Thanks.

[GerdW]

Hi Susanne,

your "ReportÖlZeigen" only puts strings in the Excel report (using "Report Easy Title" function). I don't see any place where you put real measurement values in the sheet.

The "ReportErstellen ohne Luft" is missing a lot of subVIs and calls "ReportÖlZeigen", but I also don't see any place where you write measurement values in the Excel sheets.

So:

- Where exactly do you have problems?

- Did you change Excel cell formatting to show more/less digits? Either programmatically or manually?

[Susanne1709]

I attached an Excel Sheet which is the output. Second tab ("intern") of the sheet, column E, row 54-57 - this is the problem. Periode has 2 decimal places, here I need 3. The measurements come from a database which I select before. Are the attached files helpful or do you need more?

Yes, I changed the string into number in the Excel sheet manually and the 3rd decimal place is zero. Could be zero, but also could be another number. But that's not a solution. I need to have 3 decimal places as well in the VIs because according to my client it can influence the calculations/results when this value Periode Öl has 3 decimal places. How can I change it automatically?

[GerdW]

Hi Susanne,

cell E54 on sheet "intern" is formatted as TEXT and contains just TEXT. It is NOT recognized as numeric in Excel!

As said before: To set numbers in Excel sheets you have to write NUMBERS to Excel! In your VIs you only use strings…