Disable Scientific Notation conversion

C

Clark G.

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

Bernard Liengme

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

Gary Brown

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
Text data being converted to Scientic Notation 0
opening text file converts numbers to scientific notation 1
scientific notation conversion question 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Excel does not accept text format! 0
How do I stop Excel 2007 from using scientific notation? 2

Top