Prev: Data validation list, combobox
Next: What does the number 1.26E-23 mean? Is it a large or small num
From: Tommy37 on 9 Apr 2010 06:43
What does the number 1.26E-23 mean? Is it a large or small number
From: RonaldoOneNil on 9 Apr 2010 06:53
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
From: Bob I on 9 Apr 2010 08:21
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

From: Niek Otten on 9 Apr 2010 09:21
Format as Number with 30 decimal places, then you see it

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tommy37" <Tommy37(a)discussions.microsoft.com> wrote in message
news:F839C768-27FA-4689-963E-6C905EA1D5E8(a)microsoft.com...
> What does the number 1.26E-23 mean? Is it a large or small number

From: Joe User on 9 Apr 2010 11:40
"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.
 |  Next  |  Last
Pages: 1 2
Prev: Data validation list, combobox
Next: What does the number 1.26E-23 mean? Is it a large or small num