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

Kicking and Screaming · External Since: Oct 23, 2005 Posts: 1

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

Domenic · External Since: May 03, 2004 Posts: 1063

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

'5-9

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

Hope this helps!

In article <64AE5219-035D-46E3-9488-5D01F6B012FA.DeleteThis@microsoft.com>,
Kicking and Screaming <Kicking and
Screaming.DeleteThis@discussions.microsoft.com> 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

Mika Oukka · External Since: Sep 01, 2003 Posts: 3

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 Screaming.DeleteThis@discussions.microsoft.com>
wrote in message news:64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com...
> 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