Prev: Counting occurance of empty cells
Next: Please help.,
From: Olyr150 on 27 May 2010 15:53
How do you clear a cell from doing this 1E+305? It should read 1E305.
From: Ms-Exl-Learner on 27 May 2010 15:53
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!

--------------------
(Ms-Exl-Learner)
--------------------


"Olyr150" wrote:

> How do you clear a cell from doing this 1E+305? It should read 1E305.
From: Brad on 27 May 2010 17:14
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.
 | 
Pages: 1
Prev: Counting occurance of empty cells
Next: Please help.,