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

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

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

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

'5-9

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

Hope this helps!

In article ,
Kicking and Screaming <Kicking and
wrote:

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

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

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


"Kicking and Screaming" <Kicking and
wrote in message ...
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