Date not Formatting

  • Thread starter Thread starter Newbie
  • Start date Start date
N

Newbie

I have a column that was formatted as "Date" month, day, year (ex. October
10, 2001) and when I try to change the format to "General" the date changes
to 37174.

When I entered the data it was in the form of 10/10/2001.

What do I need to do to get my original date format back in general text or
get the October 10, 2001 to work? I ultimately need to export the data to a
sql file and would like the date to be October 10, 2001.

Thanks.
 
If you format it the way it was (Mmmm dd, yyyy) and then use DTS (for SQL
Server), the date will import properly

To return to the original formatting, select the column, go to Format |
Cells | Number and select Date in the left panel. In the right panel choose
the correct format.

After you do this, the date will show in the cell as October 10, 2001, and
will appear in the formula bar as 10/10/2001. It will still transfer
correctly to SQL as a DateTime value
 
Ive tried that and it still won't work.
I'm trying to use the concatenate to join the cells and this is when it
doesn't appear correctly.

My forumula for Cell E is =CONCATENATE(A1,B1,C1,D1) the result is as
follows:

Cell A Cell B Cell C Cell D Cell E
Date: 10/10/2001 Name: John Date 37174 Name: John

I can't change the format of Cell B to General or Text, because it changes
the date to 37174.

What am I missing?

Thank.s
 
First - you don't need CONCATENATE(), just use A1&B1& etc

Second, to handle dates in this fashion use use this

=A1&text(B1,"Mmmm dd, yyy")&C1&D1

You said you want to send this data to SQL. It sure looks as if you're
going the long way around the barn to get there. Why not just export the
data without the labels?
 
=A1&TEXT(B1,"dd/mm/yyyy")&C1&D1

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
1. Thanks, I thought I needed to use concatenate to join cell content
according ot Excel help...

2. GREAT, that formula did the trick!

3. It is going to be sent to a mysql database. As you can tell with my
questions, I am new to excel and mysql stuff. So I wouldn't doubt it if I
am going about this the long way.. Learning curve is at 90 degrees!

How do I export data w/o the tables? Right now, I'm copying and pasting...

Thanks for your help.
 
Back
Top