I'm reading the contents of a Cell - formatted as custom "dd mmm
yyyy".

The text in the Cell is "08 Mar 1980".

Reading the cell magically converts it to 8/03/1980. This is done when
referencing it via Cells(line, column).

Writing this to another sheet via

Sub WriteSheet(mVal, mL, mC)
With Worksheets("Sheet3")
..Cells(mL, mC) = mVal
End With
End Sub

Sees the cell contents become 29288.

This really happens!!! And I've done hundreds of tests.... crazy !
What could possible cause it? I've varies the formatting of the
destination cell to text, and General. No change.

Why doesn't it read what it is - and write the same thing? Isn't this
the whole point ?

Thanks - Kirk