Retain date format in cell

In Excel 2003 I produce a dated schedule. When I add data to a cell the date
format changes as follows:
9-Aug to 09/08/06
The cell is custom formatted d-mmm.

How do you add data to a cell and which cell are you adding to?


Gord Dibben MS Excel MVP


On Wed, 9 Aug 2006 06:20:02 -0700, Jan 2HW <Jan [email protected]>
wrote:

>In Excel 2003 I produce a dated schedule. When I add data to a cell the date
>format changes as follows:
>9-Aug to 09/08/06
>The cell is custom formatted d-mmm.