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.

Peter Jasak wrote:
>
> 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?

--

Dave Peterson

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.
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>
> Peter Jasak wrote:
>>
>> 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?
>
> --
>
> Dave Peterson

See
http://tinyurl.com/o9bvr
excel.programmming Feb 19, 2004
Database Export
#4 by Tom Ogilvy