1-9 not as a date
 

How can i make 1-9 to be just like it is.

1-9 not as a date
 

Before entering the value:

Either format the cell as text or use an apostrophe as the first character
in the cell

'1-9


"Confused" wrote:

How can i make 1-9 to be just like it is.

1-9 not as a date
 

the simplest way is to put a apostrophy in front of it

"Confused" wrote:

How can i make 1-9 to be just like it is.