Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Cell changes from General format to Scientific

Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Cell changes from General format to Scientific

the largest number which can be entered in a cell is just under 1.8E308
your 123E306 is handled as text not a number

"flish" wrote:

Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Cell changes from General format to Scientific

I said it wrong. the 1.8E308 is the largest number which can be in the cell,
the largest number which can be typed in is 9.99...9E307

"flish" wrote:

Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 340
Default Cell changes from General format to Scientific

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Cell changes from General format to Scientific

But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 340
Default Cell changes from General format to Scientific

123E306=1.23E+308 is larger than the maximum value allowed

flish wrote:
But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks




  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Cell changes from General format to Scientific

Your number is outside the range that Excel can handle, so it is
treated as text, even if it doesn't change the cell formatting to text.


Pete

flish wrote:

But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks




  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Cell changes from General format to Scientific

I understand that Excel can't handle a number greater than 1E+308. But what I
can't understand is why 123E305 returns a value of 1.23E+307 and 123E306
returns a value of 123E306.

"Pete_UK" wrote:

Your number is outside the range that Excel can handle, so it is
treated as text, even if it doesn't change the cell formatting to text.


Pete

flish wrote:

But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Cell changes from General format to Scientific

123E305 is equivalent to 0.123 E+308 (inside the range allowed), but
123E306 is equivalent to 1.23 E+308 (outside the range allowed). What
don't you understand about that? The first one gets converted to a
number, the second one is treated as text (remains the same).

Pete

flish wrote:

I understand that Excel can't handle a number greater than 1E+308. But what I
can't understand is why 123E305 returns a value of 1.23E+307 and 123E306
returns a value of 123E306.

"Pete_UK" wrote:

Your number is outside the range that Excel can handle, so it is
treated as text, even if it doesn't change the cell formatting to text.


Pete

flish wrote:

But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks





  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Cell changes from General format to Scientific

Thank you for clearing this up for me. You help is greatly appreciated

"Pete_UK" wrote:

123E305 is equivalent to 0.123 E+308 (inside the range allowed), but
123E306 is equivalent to 1.23 E+308 (outside the range allowed). What
don't you understand about that? The first one gets converted to a
number, the second one is treated as text (remains the same).

Pete

flish wrote:

I understand that Excel can't handle a number greater than 1E+308. But what I
can't understand is why 123E305 returns a value of 1.23E+307 and 123E306
returns a value of 123E306.

"Pete_UK" wrote:

Your number is outside the range that Excel can handle, so it is
treated as text, even if it doesn't change the cell formatting to text.


Pete

flish wrote:

But when I entered 123E306 in a cell having the format of General. It returns
123E306 and retains the General formatting. It doesn't convert it to
scientific format


"Lori" wrote:

Excel only allows values less than 1E+308.

flish wrote:
Entered 123E305 in a cell having the format of General. It returns 1.23E+307
and changes the cell format to Scientfic.

Entered 123E306 in a cell having the format of General. It returns 123E306
and retains the General formatting.

What would cause this?

Thanks






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can cell format come from and change with reference cell format jclouse Excel Discussion (Misc queries) 1 November 29th 06 04:20 AM
Change CSV-load cell format from GENERAL to TEXT for numbers? Morena Chris Matthews Excel Discussion (Misc queries) 1 October 14th 05 05:23 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM


All times are GMT +1. The time now is 06:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"