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