typing mistaken for date format

start your entry with an apostrophe <'> e.g. '12-23



Excel Probs <Excel [email protected]> wrote in message
news:[email protected]...
> My data entry keeps being mistaken for a date entry and cannot be entered
> normally.
>
> Also How could I insert a dash with out excel thinking that its a
formular?
>
> My last question is when using the footer...How can I make sure the pages
> are labeled from eg. 1- 14. with the footer as page 1 of 14 and so on
for
> all the sheets in the workbook..?
>
> Thankyou!

start your entry with an apostrophe <'> e.g. '12-23



Excel Probs <Excel [email protected]> wrote in message
news:[email protected]...
> My data entry keeps being mistaken for a date entry and cannot be entered
> normally.
>
> Also How could I insert a dash with out excel thinking that its a
formular?
>
> My last question is when using the footer...How can I make sure the pages
> are labeled from eg. 1- 14. with the footer as page 1 of 14 and so on
for
> all the sheets in the workbook..?
>
> Thankyou!

My data entry keeps being mistaken for a date entry and cannot be entered
normally.

Also How could I insert a dash with out excel thinking that its a formular?

My last question is when using the footer...How can I make sure the pages
are labeled from eg. 1- 14. with the footer as page 1 of 14 and so on for
all the sheets in the workbook..?

Thankyou!

start your entry with an apostrophe <'> e.g. '12-23



Excel Probs <Excel [email protected]> wrote in message
news:[email protected]...
> My data entry keeps being mistaken for a date entry and cannot be entered
> normally.
>
> Also How could I insert a dash with out excel thinking that its a
formular?
>
> My last question is when using the footer...How can I make sure the pages
> are labeled from eg. 1- 14. with the footer as page 1 of 14 and so on
for
> all the sheets in the workbook..?
>
> Thankyou!