Correct a Cell

[Olyr150]

How do you clear a cell from doing this 1E+305? It should read 1E305.

 

[Ms-Exl-Learner]

Select the column or cells and do Right Click>>Format
Cells>>Number>>Category>>Select Text and give Ok. Now type 1E305 in the
formatted (Text) cell.

Remember to Click Yes, if this post helps!

 

[Brad]

easiest way is to add a ' before you type it in.