Disable Scientific Notation conversion

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

Guest

I need to turn-off a function in Excel that causes text data to be converted
to numbers in Scientific Notation form. I don't want my text file that
contains text to be automatically converted. Example: 83E2 will be
converted to 8.30+E3. I want it to open with 83E2 only.
 
Do you have control of how the text file gets made? If so specify a single
quote in front of this field then Excel will read text.
 
or you could use the OpenText Method in your import procedure and code in
which fields you want to be text.
HTH,
Gary Brown
 

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

text converts to scientific 1
Can scientific notation be turned off? 1
prevent scientific notation display 3
Using scientific notation in TEXT() function 1
scientific notation conversion question 3
How do I stop Excel 2007 from using scientific notation? 2
Autoformat 2
disable Scientific notation 2

Back
Top