Get rid of scientific formatting on excel.


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.
 
Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top