LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

number to excel wrong format

My vi writes numbers to excel, but the format in excel isn`t the way it should be.

My goal:
1,234 to 1,234
123,0345 to 123,0345
1,000001 to 1,000001
1,020000 to 1,02

If I use %.2f its fine but the numbers after the , are cut away.
%.6f brings funny stuff in labview.
see attached files. What is my fault?
I tried several formating possibilities.
Download All
0 Kudos
Message 1 of 2
(2,740 Views)
I'm not sure exactly, but I have a strong feeling that you are tripped up by
using the comma for a decimal point. Here in the US we use a period for a
decimal point and the comma is used to seperate hundreds from thousands from
millions, etc. That's what the .6f document looks like. I imagine that you
have labview set up to use comma as decimal point and excel is
misinterpreting it.

"Knappe" wrote in message
news:506500000008000000A3680000-1031838699000@exchange.ni.com...
> My vi writes numbers to excel, but the format in excel isn`t the way
> it should be.
>
> My goal:
> 1,234 to 1,234
> 123,0345 to 123,0345
> 1,000001 to 1,000001
> 1,020000 to 1,02
>
> If I use %.2f its fine but the numbers after the , are cut away.
> %.6f brings funny stuff in
labview.
> see attached files. What is my fault?
> I tried several formating possibilities.
0 Kudos
Message 2 of 2
(2,740 Views)