Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 117
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 905
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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
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
Easy Reading - large number minus small number MUTTMIND New Users to Excel 5 February 5th 09 11:08 AM
sum a large number of worksheets Michael Excel Discussion (Misc queries) 5 January 21st 09 06:33 PM
Looking to break a large number down David Excel Discussion (Misc queries) 0 August 17th 07 01:44 AM
Sort a small number of cells ALF0525 Excel Discussion (Misc queries) 1 October 9th 06 10:23 PM
Number in cell appears to be 10000 times too small morris Excel Discussion (Misc queries) 1 May 6th 06 11:45 PM


All times are GMT +1. The time now is 06:54 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"