what is this, how do I avoid it?

D

datadude1959

9.00418E+11
I get this when I import a list of numbers into a new spreadsheet. Ho
do I avoid this?
Thank
 
R

Ron Coderre

The value 9.00418E+11 is scientific notation and means 9.00418 x 10 t
the 11th power: 900418000000.00

To make it display properly, change the number format to something mor
appropriate:
Format>Cells>Number
Change category to Number

Adjust the column width as necessary.

Does that help?

Regards,
Ro
 
Top