I have pasted some data into my excel worksheet for analysis. The data came in a fixed format as follows:
1 1 3 .00000E+00 .00000E+00 .00000E+00 1.73071E+06 7.19820E+02 3.30813E+01 1.90435E+05
2 1 3 .00000E+00 .00000E+00 .00000E+00 1.73061E+06 7.19820E+02 4.33058E+01 2.73185E+05
2 4 3 4.90893E+00 1.59851E+01 -1.59995E+01 1.73058E+06 7.19820E+02 2.35627E+02 4.08802E+05
3 4 3 8.62909E+00 2.70697E+01 -2.33887E+01 1.73058E+06 7.19820E+02 3.67840E+02 6.91837E+05
That is, I7,I7,I7,R13,R13,R13,R13,R13,R13,R13. Where I indicates spaces assigned to integer number, and R indicates spaces assigned to real (non-integer) number. You might recognize this format as one from a FORTRAN code.
After I make some adjustment to the data, I copy and paste it back to the original file that contained the above data. However, when I do that I get the wrong format. So, I have used the following excel equation to adjust for it:
=" "&PRO_file!A6&" "&PRO_file!B6&" "&PRO_file!C6&" "&TEXT(PRO_file!N6,$B$1)&" "&TEXT(PRO_file!O6,$B$1)&" "&TEXT(PRO_file!P6,$B$1)&" "&TEXT(PRO_file!G6,$B$1)&" "&TEXT(PRO_file!H6,$B$1)&" "&TEXT(PRO_file!I6,$B$1)&" "&TEXT(PRO_file!J6,$B$1)
Where $B$1 is the number format 0.00000E+00.
This equation works for the top 2 lines of the data above (where all numbers are positive). But fails where the number becomes negative, such as in the bottom 2 lines of the above data.
Is there anything in excel to adjust for that?
Thanks in advance. Hanan.
By the way, I am dealing with close to 2000 lines of data.