Set cell value excel numeric format

[ibvp_ss]

Hello everybody!

I am working with Set cell value.vi to send data from labview to an excel worksheet. The only thing I cannot achieve is the changing of the cell´s format. For example, I send "-0.00049997" and it appears as "-5.00E-4". My goal is to show "-4.9997E-4" but I am not able to change neither the width of the number nor the digits of precision. Is it possible to modify the format of the cell?

Thank you in advanced.

Regards.

[Ranjeet_Singh]

Try this link.

[ibvp_ss]

Thank you Ranjeet for the link, but I think it is not helpful for me because I don´t have the Report Toolkit, so I think I don´t have access to that VI they are talking about for modifying...

[Ranjeet_Singh]

If you dont have report tool kit then how you are using set excel numeric format ?

[ibvp_ss]

I am only using Set cell value.vi. I found it in "Write Table to XL" example that came by default.

I cannot change the format of the cells without that toolkit?

Thanks in advance.

[.aCe. · Accepted solution]

You just need to set the NumberFormat of the cell you are writing to. The format in the snippet may not be exactly what you want, just adjust it accordingly.

[ibvp_ss]

Thank you very much .aCe.!

It works perfect now.

Regards