With date in A1

In B1 enter =TEXT(A1, "MM/DD/YYYY")

Double-click on the fill handle to increment down.

CopyPaste SpecialValues and delete column A


Gord Dibben MS Excel MVP


On Fri, 9 Feb 2007 12:21:01 -0800, Rick Sully <Rick
wrote:

I've downloaded a csv file from bank. The date needs to be in MM/DD/YYYY. I
type in in as text 01/01/2007 but when I save it it reverts back to date
format.