How do I stop dates from being entered everytime I enter a number

G

Guest

Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to
the next cell and it automatically puts in may 9 . I have tried putting in
general in formatting cells and it still does it. can someone help before I
shoot this pc out the window? I am making a population pyramid with males
and females and their ages.

Thanks,
Kicking and Screaming
 
D

Domenic

You can precede your entry with a single quote...

'5-9

....or format your cells as 'Text'.

Hope this helps!

Kicking and Screaming <Kicking and
 
M

Mika Oukka

Hello,

One way to handle this unwanted automation this is to type an apostrophe
before your class name:

'5-9

this handles the feeded data as text, but in this case it does the job.

Regards, Mika
 

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

Similar Threads

How do I count mile times under 10:00 minutes only and get a perce 2
how do i stop excel from converting numbers entered into a date 2
How do I prevent the cell from changing the number I enter? 2
Stop next cell being selected on Enter 2
how do i stop rows from being ongoing 3
How do I keep duplicate text from being entered in an excel file? 2
How do I stop Excel from copying date format from cell above? 2
Values not being recognized as dates 2

Top