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

in excel when i write 7854E25 it become a "7.854E+28" in scientific and after
changing it cannot change? please give the solution.

"
"
"

Varun

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

Hi

Either format the cells as Text before making any entries
FormatCellsText
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.

--
Regards

Roger Govier


"varun" wrote in message
...
in excel when i write 7854E25 it become a "7.854E+28" in scientific
and after
changing it cannot change? please give the solution.

"
"
"

Varun