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
--
bb