If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Correct a Cell
How do you clear a cell from doing this 1E+305? It should read 1E305.
|
#2
|
|||
|
|||
Correct a Cell
Select the column or cells and do Right ClickFormat
CellsNumberCategorySelect Text and give Ok. Now type 1E305 in the formatted (Text) cell. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Olyr150" wrote: How do you clear a cell from doing this 1E+305? It should read 1E305. |
#3
|
|||
|
|||
Correct a Cell
easiest way is to add a ' before you type it in.
-- Wag more, bark less "Olyr150" wrote: How do you clear a cell from doing this 1E+305? It should read 1E305. |
Thread Tools | |
Display Modes | |
|
|