T thelenew Nov 7, 2003 #1 I have a sheet, that I format the cell for a date EX: 12/01/03 But it returns the date 10/29/28? What's wrong here?
I have a sheet, that I format the cell for a date EX: 12/01/03 But it returns the date 10/29/28? What's wrong here?
P Paul Nov 7, 2003 #2 thelenew said: I have a sheet, that I format the cell for a date EX: 12/01/03 But it returns the date 10/29/28? What's wrong here? Click to expand... You typed in 120103. You should have included the / characters: 12/01/03. Formatting the cell as date does not affect the way you input data. It only affects the way that data is displayed.
thelenew said: I have a sheet, that I format the cell for a date EX: 12/01/03 But it returns the date 10/29/28? What's wrong here? Click to expand... You typed in 120103. You should have included the / characters: 12/01/03. Formatting the cell as date does not affect the way you input data. It only affects the way that data is displayed.
P Peo Sjoblom Nov 7, 2003 #4 Only the Pearson format here http://www.cpearson.com/excel/DateTimeEntry.htm
