7854E25 it become a "7.854E+28" in scientif & not corrected?

R

Roger Govier

Hi

Either format the cells as Text before making any entries
Format>Cells>Text
or
prefix your entry with a single quote '7845E25
The quote won't show in the cell, but will tell Excel to treat the entry
as a text entry.
 
Top