| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I convert date formatt of dd/mm/yy to mm/yy (not cell format) | Excel Discussion (Misc queries) | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| How to format cell with text and date. | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
Threaded Mode
