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.
 

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
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
text converts to scientific 1
Excel 2007 bug? Merged cells must be formatted as scientific 2
Prevent scientific formatting when creating excel sheet from vbscr 5
Scientific Notation - I wish MS Gave us a switch to turn it off 3
how can I save an excel file with long number columns in cvs form. 3
Imported numbers from Excel change to scientific notation 4

Back
Top