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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SAVE AS CSV, KEEP DATE FORMAT 2
Date format problems after csv import 2
Losing date format when saving .csv files 10
Problem formatting dates from CSV file 2
Need help with converting CUSTOM format/TEXT format to DATE format 6
Working with Date/Time 1
separating date and time 5
How to convert formatted date into text. 4

Back
Top