Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|