Get rid of scientific formatting on excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i manage to copy paste phrases such as 1E1 or 13E2 on a new Excel
sheet and receive the same results and not an exponential form such as
1.00E+01 and 1.30E+03 with values 10 and 1300? I don't believe that Excel
can't handdle this problem. Imagine importing similar texts with macros from
text files and having your text automatically converted into scientific
format.
 
One way would be to select the column (or cells) in Excel where you're
pasting the phrases and click on Format | Cells | Number | Category: Text |
OK. Then copy the phrases from wherever, switch to Excel, and click on Edit
| Paste Special | Paste: As: Text | OK.
 
Back
Top