alpha field getting turned into an exponential number

I have written an application that retrieves information and places it into
an Excel spreadsheet. I am having trouble with my Part Number field. For
example, the part number value is supposed to be 3067E17. But, that part
number is displayed as 3.07E+20 in the spreadsheet. Is there anything that I
can add to my application that would get the part number to display properly?
I have tried using NumberFormat = "@", but that did not help.

Have you tried using the NumberFormat = "@" BEFORE you actually put the
text into the cell? If not, give it a shot.

-JK

dkellison wrote:
> I have written an application that retrieves information and places it into
> an Excel spreadsheet. I am having trouble with my Part Number field. For
> example, the part number value is supposed to be 3067E17. But, that part
> number is displayed as 3.07E+20 in the spreadsheet. Is there anything that I
> can add to my application that would get the part number to display properly?
> I have tried using NumberFormat = "@", but that did not help.

I just tried using the NumberFormat = "@" before loading any data into the
cell and I still encounter the same problem.

Thanks for the repsonse.

dkellison


"JK" wrote:

> Have you tried using the NumberFormat = "@" BEFORE you actually put the
> text into the cell? If not, give it a shot.
>
> -JK
>
> dkellison wrote:
> > I have written an application that retrieves information and places it into
> > an Excel spreadsheet. I am having trouble with my Part Number field. For
> > example, the part number value is supposed to be 3067E17. But, that part
> > number is displayed as 3.07E+20 in the spreadsheet. Is there anything that I
> > can add to my application that would get the part number to display properly?
> > I have tried using NumberFormat = "@", but that did not help.
>
>

This works for me:
ActiveCell.NumberFormat = "@"
ActiveCell.Value = "3067E17"

Or, irrespective of the formatting:
ActiveCell.Value = "'3067E17"

NickHK

"dkellison" <[email protected]> wrote in message
news:[email protected]...
> I just tried using the NumberFormat = "@" before loading any data into the
> cell and I still encounter the same problem.
>
> Thanks for the repsonse.
>
> dkellison
>
>
> "JK" wrote:
>
> > Have you tried using the NumberFormat = "@" BEFORE you actually put the
> > text into the cell? If not, give it a shot.
> >
> > -JK
> >
> > dkellison wrote:
> > > I have written an application that retrieves information and places it
into
> > > an Excel spreadsheet. I am having trouble with my Part Number field.
For
> > > example, the part number value is supposed to be 3067E17. But, that
part
> > > number is displayed as 3.07E+20 in the spreadsheet. Is there anything
that I
> > > can add to my application that would get the part number to display
properly?
> > > I have tried using NumberFormat = "@", but that did not help.
> >
> >