Retain date format in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom footer date format 2
Show a date based on another date 1
Date Format 3
Date Calculation & Conditional Formatting 3
Date Time formatting problem 7
custom date format 1
retain custom date format "text" when pasting or reformatting data 2
Date Format 1

Back
Top