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
*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
*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
*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
*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
*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
*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
*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
*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
*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" wrote in message
...

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