Thread: one column on my excel spreadsheet will NOT format the date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MeMe
 
Posts: n/a
Default one column on my excel spreadsheet will NOT format the date

Not without using VBA code.

See Chip Pearson's site for methods.

http://www.cpearson.com/excel/DateTimeEntry.htm

--
T-Ray


"mrm" wrote:

Not matter which way I try to format the cells to take a date (i.e. ##/##/##)
when I enter the date needed (i.e. 061405) it comes out either 19## or 202#.
Reply With QuoteReply With Quote