Get rid of scientific format on Excel 2003

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.
 

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 formatting on excel. 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Paste to excel from word - auto format problem 1
Import hexadecimal data into excel keeping hexadecimal format 1
Excel is converting my alphanumeric text to scientific notation 2
cell formatting ends up scientific? 1
Stop Excel converting csv values to scientific format 2
Automatic scientific format when entering 5E100 3

Top