Get rid of scientific formatting on excel.

S

Spyros

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

garfield-n-odie

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

Similar Threads

Get rid of scientific format on Excel 2003 1
Excel is converting my alphanumeric text to scientific notation 2
Scientific Notation - I wish MS Gave us a switch to turn it off 3
webquery loses format of leading zero and to scientific 2
automatic formatting on import of .DIF files 3
How do I get rid of showing hyperlinks as "{ HYPERLINK ...}? 1
Excel 2007 text import as text not date 3
How to get rid of web page objects ? 9

Top