View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Retain date format in cell

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