why does the year 2006 appear as 2005?
 

When I enter the year 2006 in any worksheet, it appears as 2005. I can put a
comma infront, but dont really want to do this each time.

why does the year 2006 appear as 2005?
 

Have you looked at Tools/ Autocorrect Options?
--
David Biddulph

"Nat" wrote in message
...
When I enter the year 2006 in any worksheet, it appears as 2005. I can put
a
comma infront, but dont really want to do this each time.

why does the year 2006 appear as 2005?
 

Hi David, that worked just fine! I have no clue why it was set to replace
2006 with 2005. Thanks!

"David Biddulph" wrote:

Have you looked at Tools/ Autocorrect Options?
--
David Biddulph

"Nat" wrote in message
...
When I enter the year 2006 in any worksheet, it appears as 2005. I can put
a
comma infront, but dont really want to do this each time.

why does the year 2006 appear as 2005?
 

Glad it worked for you.
--
David Biddulph

"Nat" wrote in message
...
Hi David, that worked just fine! I have no clue why it was set to replace
2006 with 2005. Thanks!

"David Biddulph" wrote:

Have you looked at Tools/ Autocorrect Options?

"Nat" wrote in message
...
When I enter the year 2006 in any worksheet, it appears as 2005. I can
put
a
comma infront, but dont really want to do this each time.