Excel - CSV file, trying to save a date as text, reverts back to d

R

Rick Sully

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.
 
G

Gord Dibben

With date in A1

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

Double-click on the fill handle to increment down.

Copy>Paste Special>Values and delete column A


Gord Dibben MS Excel MVP


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