Number 6 shows as s

[Zelfan]

Lately, whenever I start a new file and type a number or date in a cell with
a single digit 6, it shows as the letter s, for example 6/6/2006 shows as
s/s/2006. If I preceed the number with a zero or in a multiple digit number,
it shows as a regular 6.
I have tried to change it using formatting the cell, but it does not change
it. Can any one help.

Thank you.

[Paul B]

Zelfan, look under tools, autocorrect and see if 6 is being replaced by as s

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Zelfan" <Zelfan@discussions.microsoft.com> wrote in message
news:70E3385B-91EC-4CC9-B8A3-61BD67E960CE@microsoft.com...
> Lately, whenever I start a new file and type a number or date in a cell
with
> a single digit 6, it shows as the letter s, for example 6/6/2006 shows as
> s/s/2006. If I preceed the number with a zero or in a multiple digit
number,
> it shows as a regular 6.
> I have tried to change it using formatting the cell, but it does not
change
> it. Can any one help.
>
> Thank you.

[zelfan]

Yes, that was the problem and it was corrected as soon as I deleted it
from autocorrect. Paul, thanks for your invaluable help. It was
driving me crazy.

Zelfan,

Paul B wrote:
> Zelfan, look under tools, autocorrect and see if 6 is being replaced by as s
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Zelfan" <Zelfan@discussions.microsoft.com> wrote in message
> news:70E3385B-91EC-4CC9-B8A3-61BD67E960CE@microsoft.com...
> > Lately, whenever I start a new file and type a number or date in a cell
> with
> > a single digit 6, it shows as the letter s, for example 6/6/2006 shows as
> > s/s/2006. If I preceed the number with a zero or in a multiple digit
> number,
> > it shows as a regular 6.
> > I have tried to change it using formatting the cell, but it does not
> change
> > it. Can any one help.
> >
> > Thank you.

[Paul B]

your welcome, and thanks for the feedback

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"zelfan" <zelfan@hotmail.com> wrote in message
news:1150682073.887039.272950@g10g2000cwb.googlegroups.com...
> Yes, that was the problem and it was corrected as soon as I deleted it
> from autocorrect. Paul, thanks for your invaluable help. It was
> driving me crazy.
>
> Zelfan,
>
> Paul B wrote:
> > Zelfan, look under tools, autocorrect and see if 6 is being replaced by
as s
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Zelfan" <Zelfan@discussions.microsoft.com> wrote in message
> > news:70E3385B-91EC-4CC9-B8A3-61BD67E960CE@microsoft.com...
> > > Lately, whenever I start a new file and type a number or date in a
cell
> > with
> > > a single digit 6, it shows as the letter s, for example 6/6/2006 shows
as
> > > s/s/2006. If I preceed the number with a zero or in a multiple digit
> > number,
> > > it shows as a regular 6.
> > > I have tried to change it using formatting the cell, but it does not
> > change
> > > it. Can any one help.
> > >
> > > Thank you.
>