Disable Scientific Notation conversion

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.
--
Client Server Developer

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.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Clark G." <[email protected]> wrote in message
news:[email protected]...
>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.
> --
> Client Server Developer

or you could use the OpenText Method in your import procedure and code in
which fields you want to be text.
HTH,
Gary Brown

"Clark G." wrote:

> 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.
> --
> Client Server Developer