Hi,

I am getting a strange problem. I have tried several ways but finally
left it. I have got a sheet where one of the cells has a date value
displayed in the cell as Jan-04. When the cell is clicked the value
that is shown on the top in the formula bar is 04/01/2004. But when I
am writing the value of this cell to a cell in another sheet the value
is beinmg shown as 01/04/2004.

How can I resolve this?

Thanks in advance.