Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default 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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"