Excel spreadsheet Date formatting

P

Paul

JW said:
When I enter dates, it always appears January 01,2003 no
matter how I format the cell

What, precicely, are you typing in when you 'enter a date'? Give an example
of exactly what you type. How is the cell formatted before you type this in?
What is displayed immediately after pressing Enter? Does this change at all
if you alter the format after typing it in?
 
Top