Numbers to dates

A

André

Hey all, I am trying to enter in #'s like 5-9, 10-14, 15-
19 in seperate cells. Now every time I do this it keeps
changing the cells into date format. I've tried changing
it to general and just number but it automaticly changes
it to date. How can i stop/fix this?

A.
 
E

Et3rnal

Do you want this 25 days to be added on the date of opening? There for
changing every time you open it
 
G

Guest

-----Original Message-----
Hey all, I am trying to enter in #'s like 5-9, 10-14, 15-
19 in seperate cells. Now every time I do this it keeps
changing the cells into date format. I've tried changing
it to general and just number but it automaticly changes
it to date. How can i stop/fix this?

A.Change it to TEXT format.
.
 
Top