Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Date Formatting Won't ChangeHave you tried the Text-to-Columns trick akaal_sahaye mentioned above? It worked for me. Kind of crazy to have to do this as a work-around, but now that I know it, it is fairly simple to implement.Re: Date Formatting Won't Change SergeiBaklan Data > Text to Columns with date format worked for me, thanks. Before that, even pressing F2 to edit the cell and press enter was insufficient to have it auto-recognize as a date, which seemed odd to me.