Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
What does the number 1.26E-23 mean? Is it a large or small number
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
Its a huge number. The E stands for exponetial and the 23 means 23 decimal
places to the right. 126,000,000,000,000,000,000,000 "Tommy37" wrote: What does the number 1.26E-23 mean? Is it a large or small number |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small num
Or, maybe, 0.0000000000000000000000126
Micky "RonaldoOneNil" wrote: Its a huge number. The E stands for exponetial and the 23 means 23 decimal places to the right. 126,000,000,000,000,000,000,000 "Tommy37" wrote: What does the number 1.26E-23 mean? Is it a large or small number |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
the negative indicates that the decimal is 23 places to the left of
where you see it. Tommy37 wrote: What does the number 1.26E-23 mean? Is it a large or small number |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
Format as Number with 30 decimal places, then you see it
-- Kind regards, Niek Otten Microsoft MVP - Excel "Tommy37" wrote in message ... What does the number 1.26E-23 mean? Is it a large or small number |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
"Tommy37" wrote:
What does the number 1.26E-23 mean? Is it a large or small number It is a very very small number, very close to zero. I wonder if your real question is: how do you avoid it? If you are entering numeric strings longer than 15 digits (account numbers, product serial numbers, etc.), you should enter them as text. Exactly how to do that depends on how you are entering the data. If you entering them manually, simply put an apostrophe (') in front of the numeric string. If you see numbers of that form as a result of computation, you probably should round the computation, either by using the ROUND function or by setting the Precision As Displayed calculation option (Tools Options Calculation in Excel 2003). I usually deprecate the use of PAD, however. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does the number 1.26E-23 mean? Is it a large or small number
No, it is a very small number. Ronaldo missed the minus sign in front of
the number 23. You need to move the decimal point in the opposite direction. -- David Biddulph "RonaldoOneNil" wrote in message ... Its a huge number. The E stands for exponetial and the 23 means 23 decimal places to the right. 126,000,000,000,000,000,000,000 "Tommy37" wrote: What does the number 1.26E-23 mean? Is it a large or small number |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy Reading - large number minus small number | New Users to Excel | |||
sum a large number of worksheets | Excel Discussion (Misc queries) | |||
Looking to break a large number down | Excel Discussion (Misc queries) | |||
Sort a small number of cells | Excel Discussion (Misc queries) | |||
Number in cell appears to be 10000 times too small | Excel Discussion (Misc queries) |