1E1 Cell Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
Click to expand...

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.
 
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.
Click to expand...

--
(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??
 
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??
Click to expand...

--
(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
 
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??
Click to expand...

Yes there is. Format the cell as text before you type in.
 
Back
Top