Can't Format Date

B

bbsan

I select a column, FORMAT CELLS/DATE
Select mm/dd/yy
When I type in 031506 I get 040486

Transition Formula Entry is UNCHECKED

I've tried all the DATE and CUSTOM options.

Thank you
 
N

Niek Otten

Type 3/15/06

31506 is the date sequence number; the number of days since 1/1/1900
 
B

bbsan

hmm

Then what's the purpose of the FORMAT CELLS/DATE option?

I'm trying to set the format so I don't have to type the /, just the numbers
031506 and have the formatted cell render the numbers in date format.
 
Top