Scientific Formatting takes over - how to stop...
 

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

Or just preced it with an ', such as in '1E07 or '1e07. Excel will then take
it as text.

"Dave F" wrote:

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

I've tried changing the formatting. when I go, it appears as:
10000000

And if I try to re-type the 1E07, it goes right back to scientific.

"Dave F" wrote:

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

Nevermind - I finally got it to "stick" with the text formatting. Thanks!

"Dave F" wrote:

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

Did you change the formatting to Text or General?
--
Brevity is the soul of wit.


"Abi" wrote:

I've tried changing the formatting. when I go, it appears as:
10000000

And if I try to re-type the 1E07, it goes right back to scientific.

"Dave F" wrote:

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!

Scientific Formatting takes over - how to stop...
 

Seems to me the answer to this is to put an apostrophe to the left, as was
suggested earlier.
--
Brevity is the soul of wit.


"Abi" wrote:

I've tried changing the formatting. when I go, it appears as:
10000000

And if I try to re-type the 1E07, it goes right back to scientific.

"Dave F" wrote:

Excel thinks you're trying to write 1*10^7; i.e., 10 million, in scientific
notation.

Best way to avoid this is to format your cells as Text or General, which
forces Excel to ignore exponentiation.

Dave
--
Brevity is the soul of wit.


"Abi" wrote:

Using Excel 2002

I'm assigning session numbers to some classes in a general spreadsheet:

1A07
1B07
1C07
1D07

When type in 1E07 it automatically transforms it into:
1.00E+07

And I noticed that any time I use "E" it does this. I've tried to put
spaces in front but that doesn't make a difference.

Since I'm not a science whiz, can someone tell me what's going on and if I
can fix it?

Thank you!