how do I enter a number so that it doesn't convert into a date?
 

I'm trying to write seom results for a practicle, and I want to write numbers
such as 12-13, but what can I do so that they don't convert into dates such
as 13th of dec?? I tried to look around for a button that would stop thif
from happenening, but I'm not sure if there even is one!

how do I enter a number so that it doesn't convert into a date?
 

Either preformat the cells as TEXT or precede the entries with an apostrophe
'. The apostrophe will not be displayed in the cell.

'12-13

Biff

"Raquel" wrote in message
...
I'm trying to write seom results for a practicle, and I want to write
numbers
such as 12-13, but what can I do so that they don't convert into dates
such
as 13th of dec?? I tried to look around for a button that would stop thif
from happenening, but I'm not sure if there even is one!

how do I enter a number so that it doesn't convert into a date?
 

Raquel

Pre-format the cells to Text or precede the 12-13 with an apostrophe, which
won't be visible in the cell.


Gord Dibben MS Excel MVP


On Sat, 2 Dec 2006 11:54:00 -0800, Raquel
wrote:

I'm trying to write seom results for a practicle, and I want to write numbers
such as 12-13, but what can I do so that they don't convert into dates such
as 13th of dec?? I tried to look around for a button that would stop thif
from happenening, but I'm not sure if there even is one!