Converting Numbers to Dates

T

Teri

I receive a file in .csv format. The dates are displayed as 2242004 (February 24, 2004). I must export this to a client in Excel form with the date formatted as 2/24/04. Can anyone help please?
 
C

clintonG

You'll have to use the Excel help file to learn to write a VBA macro
that will reformat the data after it has been imported into Excel, hire
somebody to do so, or hire somebody to write an ASP/VBS script to
modify the CSV before it is imported into Excel where it will
then be exported to .xsl if I understand you correctly.

In any event, you probably need to hire some scripting help...

--
<%= Clinton Gallagher
A/E/C Consulting, Web Design, e-Commerce Software Development
Wauwatosa, Milwaukee County, Wisconsin USA
NET (e-mail address removed)
URL http://www.metromilwaukee.com/clintongallagher/



Teri said:
I receive a file in .csv format. The dates are displayed as 2242004
Click to expand...
(February 24, 2004). I must export this to a client in Excel form with the
date formatted as 2/24/04. Can anyone help please?
 

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

VBA - exporting serial letters to single documents 0
Date Formats 4
Excel does not accept text format! 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Convert PDF to Visio File or Editable PDF in Visio 0
cannot find which label format i need 1
Images are pixelated when saving to PDF 0
Macros to convert Data into date format and then plot in graph 7

Top