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

A

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
 
R

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?
 
A

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?
Click to expand...

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

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.
 
A

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.
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

yet another date format problem 1
Date Format 3
Date Format Problem. 2
How to get the 1st of the next month's date? 1
Show date, time & day of week in one cell 2
Date format issue 2
Forcing a date entry format of dd/mm/yyyy 1
Dlookup 7

Top