How to write 14.316523E-06 to spreadsheetfile

[Donkey Rubarb]

I want to write a string of format %f (for ex. 14.316523E-06...)to a spreadsheet file, the result I get is 0.000014. So the result is limited to 7- digits and this way I lose some important precision. I use the write to spreadsheet file vi with format %f and I changed the representation to EXT but without any result.
Anybody?????

[Alberto]

Hi,

use %e as string format instead, eventually you can set the number of digit of precision ex: %.3e

Good luck,

Alberto

[Dave Langstaff]

f_d wrote:
> I want to write a string of format %f (for ex. 14.316523E-06...)to a
> spreadsheet file, the result I get is 0.000014. So the result is
> limited to 7- digits and this way I lose some important precision. I
> use the write to spreadsheet file vi with format %f and I changed the
> representation to EXT but without any result.
> Anybody?????

You should be using %.9e to get scientific notation. (eg. 1.23456789e+26)

Have a look in the help under Format Specifiers Syntax Elements


--
Remove "spamkill." when replying to this message

[noname]

> Have a look in the help under Format Specifiers Syntax Elements
...
or make an 'format into string' function, rigth click on it and togle 'edit
format string' ... I think that is the easies way to work with format
strings


/ Peter