Disabling exponentiation.

  • Thread starter Thread starter Peter Jasak
  • Start date Start date
P

Peter Jasak

We have several part numbers in our inventory system that begin with '7E'.
When we download these part numbers into Excel they are converted to
exponential format instead of general or text, even if the entire worksheet
was pre-formatted for text. Is there a way to disable or turn off the
formatting of exponential numbers?
 
Can you save the inventory files as a .txt file? Then you can use File|Open to
open that file.

You'll be prompted for how to treat each field. You can choose text for this
one.
 
We can do that, but it is the intermediate step that we would like to avoid.
If it is not possible to avoid the file to text to Excel by diasabling the
automatic formatting then we will have to live with it.
 

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

Help with vlookup 1
Imported data from excel showing as exponential number in Access 1
16 digit # formats to Exponential & rounds off??? 5
status bar sum function 5
Protect Number Format Only 7
Protect Number Format Only 6
Trim and Substitute not working 4
Export to .csv while cell contains the text1E001 but it is NOT an exponential 4

Back
Top