In Excel I type 24E1 in a cell it changes ...
 

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Ann

Type an apostrophe ' and then the branch code 24E1 and all should be OK.

Mike

"Ann B" wrote:

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Either format the cell as text, or precede the 24E1 with an apostrophe.

"Ann B" wrote:

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Either format the cells before hand as TEXT format, or when entering any
thing that can be construed as a number, use an apostrophe as a prefix to
your entry to make it text.

Hope this helps...
--
Kevin Backmann


"Ann B" wrote:

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Precede the entry with an apostrophe or pre-format the cell as TEXT.


--
Biff
Microsoft Excel MVP


"Ann B" wrote in message
...
even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need
in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Thank you both for your helpful answers. Why was it doing that? I always
like to know the reasons behind things just in case I come across it again in
a different but similar situation? What in the Scientific functions would
that be interpeting?

"AnotherNewGuy" wrote:

Either format the cell as text, or precede the 24E1 with an apostrophe.

"Ann B" wrote:

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.

In Excel I type 24E1 in a cell it changes ...
 

Your entry of 24E1 was treated as a number entered in scientific notation.
Hence the value transformation when it was not entered a label or entered
into a cell formatted as text.

--
Kevin Backmann


"Kevin B" wrote:


Either format the cells before hand as TEXT format, or when entering any
thing that can be construed as a number, use an apostrophe as a prefix to
your entry to make it text.

Hope this helps...
--
Kevin Backmann


"Ann B" wrote:

even when I put the formatting as General. No matter what it keeps going
back to Scientific format afterwards. Help? This is a branch code I need in
this spreadsheet for import into a HRIS system.