View Single Post
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Jazzy1980 wrote:
This has come up on an excel spreadsheet. How do I change this into a number?
1.00311E+14.


That is a number, equal to 1.00311 with the decimal point moved to the
right by 14 places. You can format it as a fixed point number if you
wish by selecting it's cell and clicking on FormatCells. Then tell it
to use "number" format rather than "scientific". It will probably just
show you a bunch of ##### which means that your column isn't wide enough
to display so large a number.

Generally speaking, if you have such a large number it's easier to
understand it with scientific notation than with fixed point.

Bill