R data with -e, interpreted as 10^14x greater in Excel..

[Susann]

Dear all,

With R I performed some statistics and retrieved a list of p-values in a text file. However, I realised that somehow the number '6.81892250320003e-306' from R is automatically changed to '6,81892250320003E-292'. This difference of e14 is present in most p-values, although some show a difference of e13 (e.g. from '4.1654543126912e-111' to '4,1654543126912E-98' ).

I am really puzzled by this fenomenon and have tried changing the settings from 'Number' to 'General' and both opening the output file from R in Excel as well as copying the separate numbers (one or two of them) from the .txt file to Excel. Unfortunately, no success. It keeps happening.

The info of the text file I created with R: (sep="\t",col.names=T,row.names=F,quote=F)

Does anyone know what's going on here or how I can deal with this?

Thank you very much in advance!

[shg]

Look like the decimal point out of R is interpreted as the thousands separator in Excel.

Options > Advanced, Editing Options -- what are your decimal and thousands separators?

[Susann]

WOw, that turned out to be solved really quickly. Thank you very much!

[shg]

You're welcome.