1E1 Cell Entries

Can anybody help with a small issue we have?

We run a few reports from a 3rd party UNIX system which export into Excel.
These reports contain stock locations, some of which are represented by 1E1.
However, when I export these into Excel, they are automatically concerted
into the Scientific Category and show as 1.00E+01.

My question is this, is there a way to SWITCH OFF this automatic conversion
to ensure that my stock locations of 1E1 remain as 1E1?

Thanks.

Nel post news:4F24FF5D-616F-446A-A4D9-A0D0374EB85F@microsoft.com
*Ripley* ha scritto:

> Can anybody help with a small issue we have?
>
> We run a few reports from a 3rd party UNIX system which export into
> Excel. These reports contain stock locations, some of which are
> represented by 1E1. However, when I export these into Excel, they are
> automatically concerted into the Scientific Category and show as
> 1.00E+01.
>
> My question is this, is there a way to SWITCH OFF this automatic
> conversion to ensure that my stock locations of 1E1 remain as 1E1?
>
> Thanks.

How do you import these data in Excel? Because if you use the Text Wizard
you have the opportunity, in step 3, to set the column format of each column
of the file you are importing. So you need to set the stock location column
format to text.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Franz,

Thanks for your reply.
The 3rd party application exports the data directly into Excel by just
opening up a new workbook and placing the data on worksheet 1. So there's no
setting of columns that actually goes on at all.
It's just as if Excel is, by default, amending any entries for 1E1. I need
to stop it doing this though.

"Franz Verga" wrote:

> Nel post news:4F24FF5D-616F-446A-A4D9-A0D0374EB85F@microsoft.com
> *Ripley* ha scritto:
>
> > Can anybody help with a small issue we have?
> >
> > We run a few reports from a 3rd party UNIX system which export into
> > Excel. These reports contain stock locations, some of which are
> > represented by 1E1. However, when I export these into Excel, they are
> > automatically concerted into the Scientific Category and show as
> > 1.00E+01.
> >
> > My question is this, is there a way to SWITCH OFF this automatic
> > conversion to ensure that my stock locations of 1E1 remain as 1E1?
> >
> > Thanks.
>
> How do you import these data in Excel? Because if you use the Text Wizard
> you have the opportunity, in step 3, to set the column format of each column
> of the file you are importing. So you need to set the stock location column
> format to text.
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

If you cannot have a text file exported from the 3rd party application,
AFAIK I think you need to modify the 3rd party application way to export
data to Excel, to avoid such a beaviour...

Nel post news:B6DDB6BE-F3A9-459E-9589-6B961698408A@microsoft.com
*Ripley* ha scritto:

> Franz,
>
> Thanks for your reply.
> The 3rd party application exports the data directly into Excel by just
> opening up a new workbook and placing the data on worksheet 1. So
> there's no setting of columns that actually goes on at all.
> It's just as if Excel is, by default, amending any entries for 1E1. I
> need to stop it doing this though.
>
> "Franz Verga" wrote:
>
>> Nel post news:4F24FF5D-616F-446A-A4D9-A0D0374EB85F@microsoft.com
>> *Ripley* ha scritto:
>>
>>> Can anybody help with a small issue we have?
>>>
>>> We run a few reports from a 3rd party UNIX system which export into
>>> Excel. These reports contain stock locations, some of which are
>>> represented by 1E1. However, when I export these into Excel, they
>>> are automatically concerted into the Scientific Category and show as
>>> 1.00E+01.
>>>
>>> My question is this, is there a way to SWITCH OFF this automatic
>>> conversion to ensure that my stock locations of 1E1 remain as 1E1?
>>>
>>> Thanks.
>>
>> How do you import these data in Excel? Because if you use the Text
>> Wizard you have the opportunity, in step 3, to set the column format
>> of each column of the file you are importing. So you need to set the
>> stock location column format to text.
>>
>> --
>> Hope I helped you.
>>
>> Thanks in advance for your feedback.
>>
>> Ciao
>>
>> Franz Verga from Italy

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Franz,

Yes but if I go into Excel anyway and type 1E1 into any cell on any
worksheet, it gets converted into a scientific category format.

It is THIS auto conversion that I need to switch off. In order words, you
can type in 1E1 without Excel converting it into the scientific category.
Surely there is a way to turn this off or stop it converting??

"Franz Verga" wrote:

> If you cannot have a text file exported from the 3rd party application,
> AFAIK I think you need to modify the 3rd party application way to export
> data to Excel, to avoid such a beaviour...
>
> Nel post news:B6DDB6BE-F3A9-459E-9589-6B961698408A@microsoft.com
> *Ripley* ha scritto:
>
> > Franz,
> >
> > Thanks for your reply.
> > The 3rd party application exports the data directly into Excel by just
> > opening up a new workbook and placing the data on worksheet 1. So
> > there's no setting of columns that actually goes on at all.
> > It's just as if Excel is, by default, amending any entries for 1E1. I
> > need to stop it doing this though.
> >
> > "Franz Verga" wrote:
> >
> >> Nel post news:4F24FF5D-616F-446A-A4D9-A0D0374EB85F@microsoft.com
> >> *Ripley* ha scritto:
> >>
> >>> Can anybody help with a small issue we have?
> >>>
> >>> We run a few reports from a 3rd party UNIX system which export into
> >>> Excel. These reports contain stock locations, some of which are
> >>> represented by 1E1. However, when I export these into Excel, they
> >>> are automatically concerted into the Scientific Category and show as
> >>> 1.00E+01.
> >>>
> >>> My question is this, is there a way to SWITCH OFF this automatic
> >>> conversion to ensure that my stock locations of 1E1 remain as 1E1?
> >>>
> >>> Thanks.
> >>
> >> How do you import these data in Excel? Because if you use the Text
> >> Wizard you have the opportunity, in step 3, to set the column format
> >> of each column of the file you are importing. So you need to set the
> >> stock location column format to text.
> >>
> >> --
> >> Hope I helped you.
> >>
> >> Thanks in advance for your feedback.
> >>
> >> Ciao
> >>
> >> Franz Verga from Italy
>
> --
> (I'm not sure of names of menus, options and commands, because
> translating from the Italian version of Excel...)
>
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>

No way. Excel try to "translate" everything you input in a most suitable
format.

The only thing you can try is preformatting as text the cell you digit in.

But if importing from your 3rd party program is automatic and you can't do
nothing to change the formatting while importing data, IMHO the only thing
you can do is changing the way the 3rd party application export data.


Nel post news:4CBED958-68D5-4DD8-A884-6F86F4226C04@microsoft.com
*Ripley* ha scritto:

> Franz,
>
> Yes but if I go into Excel anyway and type 1E1 into any cell on any
> worksheet, it gets converted into a scientific category format.
>
> It is THIS auto conversion that I need to switch off. In order words,
> you can type in 1E1 without Excel converting it into the scientific
> category. Surely there is a way to turn this off or stop it
> converting??
>
> "Franz Verga" wrote:
>
>> If you cannot have a text file exported from the 3rd party
>> application, AFAIK I think you need to modify the 3rd party
>> application way to export data to Excel, to avoid such a beaviour...
>>
>> Nel post news:B6DDB6BE-F3A9-459E-9589-6B961698408A@microsoft.com
>> *Ripley* ha scritto:
>>
>>> Franz,
>>>
>>> Thanks for your reply.
>>> The 3rd party application exports the data directly into Excel by
>>> just opening up a new workbook and placing the data on worksheet 1.
>>> So there's no setting of columns that actually goes on at all.
>>> It's just as if Excel is, by default, amending any entries for 1E1.
>>> I need to stop it doing this though.
>>>
>>> "Franz Verga" wrote:
>>>
>>>> Nel post news:4F24FF5D-616F-446A-A4D9-A0D0374EB85F@microsoft.com
>>>> *Ripley* ha scritto:
>>>>
>>>>> Can anybody help with a small issue we have?
>>>>>
>>>>> We run a few reports from a 3rd party UNIX system which export
>>>>> into Excel. These reports contain stock locations, some of which
>>>>> are represented by 1E1. However, when I export these into Excel,
>>>>> they are automatically concerted into the Scientific Category and
>>>>> show as
>>>>> 1.00E+01.
>>>>>
>>>>> My question is this, is there a way to SWITCH OFF this automatic
>>>>> conversion to ensure that my stock locations of 1E1 remain as 1E1?
>>>>>
>>>>> Thanks.
>>>>
>>>> How do you import these data in Excel? Because if you use the Text
>>>> Wizard you have the opportunity, in step 3, to set the column
>>>> format of each column of the file you are importing. So you need
>>>> to set the stock location column format to text.
>>>>
>>>> --
>>>> Hope I helped you.
>>>>
>>>> Thanks in advance for your feedback.
>>>>
>>>> Ciao
>>>>
>>>> Franz Verga from Italy
>>
>> --
>> (I'm not sure of names of menus, options and commands, because
>> translating from the Italian version of Excel...)
>>
>> Hope I helped you.
>>
>> Thanks in advance for your feedback.
>>
>> Ciao
>>
>> Franz Verga from Italy

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

"Ripley" <Ripley@discussions.microsoft.com> wrote in message
news:4CBED958-68D5-4DD8-A884-6F86F4226C04@microsoft.com...

> Yes but if I go into Excel anyway and type 1E1 into any cell on any
> worksheet, it gets converted into a scientific category format.
>
> It is THIS auto conversion that I need to switch off. In order words, you
> can type in 1E1 without Excel converting it into the scientific category.
> Surely there is a way to turn this off or stop it converting??

Yes there is. Format the cell as text before you type in.
--
David Biddulph