53E00 DISPLAYED IN EXCEL

  • Thread starter Thread starter CATH
  • Start date Start date
C

CATH

Hello. Does anyone know why when we key in 5E300 into
spreadsheets it shows as 5.00E+300? similarly this
happens with 1E300, 2E300, 3E300 etc but not with 5C300 or
other letters. 5E100 shows as 5.00E+100. It seems that
it's the E here causing the problem as when other numbers
are used the data is displayed as typed. This is a code
we use at work by the way and although I can get round it
by using the ' key at the start I'm curious.
any ideas?
thanks
 
Cath,

The "E" character indicates to Excel that the number is in scientific
notation. So 5E300 represents 5 * 10^300, or 5 followed by 300 zeros.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
To Excel 5E300 is a number entered in
scientific notation, so as you have discovered,
it must be entered with ' or format the cell
as Text *prior* to entering the expression.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Back
Top