Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |