Numbers to dates

  • Thread starter Thread starter =?iso-8859-1?B?QW5kcuk=?=
  • Start date Start date
?

=?iso-8859-1?B?QW5kcuk=?=

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.
 
Precede the entry with an apostrophe ' or pre-format cells as text
 
-----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.
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top