excel splitting problem

[blackdaimon]

hey guys! im having a bit of an issue with excel..giving me huge troubles with my final thesis

so im working on a program that does some calculations for me and returns them in this stracture :

example:

 

1.00000e-03     3.41367e+00
2.00000e-03     2.24424e+00
3.00000e-03     2.07113e+00
4.00000e-03     2.16741e+00
5.00000e-03     2.32506e+00
6.00000e-03     2.49303e+00
7.00000e-03     2.65522e+00
8.00000e-03     2.80859e+00
9.00000e-03     2.95254e+00
1.00000e-02     3.08564e+00
1.10000e-02     3.20921e+00
1.20000e-02     3.32248e+00

 

but i want the data above to be seperated into 2 individual columns so i put them in excel . data>text to columns> etc and split them in two individual columns as i want them to be. the problem though is that it returns the wrong data..

 

1,00E+02	3,41E+05
2,00E+02	2,24E+05
3,00E+02	2,07E+05
4,00E+02	2,17E+05
5,00E+02	2,33E+05
6,00E+02	2,49E+05
7,00E+02	2,66E+05
8,00E+02	2,81E+05
9,00E+02	2,95E+05
1,00E+03	3,09E+05
1,10E+03	3,21E+05
1,20E+03	3,32E+05

 

as you can see every (-) has become (+) which is wrong and unwanted.. no matter what i do, i even changed the definition of (.) and (,) in the process while spliting them, the result remains the same.

 

can anyone help me? how can i fix this ? its extremely important that i fix this issue asap.

 

thank you very much in advance!

[PlutoNZL]

All of your issues are caused by regional settings. See here on how to fix: http://www.howtogeek.com/245510/how-to-change-excels-decimal-separators-from-periods-to-commas/

 

If comma is considered the decimal separator and period is considered the thousands separator, then 1,00E+02 and 1.00000e-03 are actually equal.

1,00E+02 = 100

1.00000e-03 = 100

[blackdaimon]

oh!!  thank you very much! 

cheers!