Very strange date format behavior: 06 > 2006 / 07 > 07

[AA Arens]

I have to cells formatted as date dd-mm-yy.

I one cell when I fill in dd-mm-06 I get dd-mm-2006
I the other cell when I fill in dd-mm-07 I get dd-mm-07

Only a format "Text" solves this problem.

How can it happen?? I haven't find out with other dates and formats.

Bart
Ex 2003

 

[Roger Govier]

Hi

What happens if you click on the cell showing dd-mm-07, click the Format
Painter icon, and "paint" over the cell showing dd-mm-2006?
Does that cure the problem?

 

[AA Arens]

Hi

What happens if you click on the cell showing dd-mm-07, click the Format
Painter icon, and "paint" over the cell showing dd-mm-2006?
Does that cure the problem?

I indeed have tried the Painter because thats the only tool to get all
formats synchronized. But without success.

 

[Roger Govier]

Hi

If you would like to mail a copy direct to me, I would be happy to take
a look and see if I can spot the problem.
To send direct remove NOSPAM from my address.

 

[AA Arens]

Hi

If you would like to mail a copy direct to me, I would be happy to take
a look and see if I can spot the problem.
To send direct remove NOSPAM from my address.

Thanks Rogier, I will do. What is your name before the @ ?

 

[Roger Govier]

roger

--
Regards

Roger Govier

Thanks Rogier, I will do. What is your name before the @ ?