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

R

Raquel

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!
 
T

T. Valko

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
 
G

Gord Dibben

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
 
Top