convert date to different format

I

ILoveMyCorgi

I have data in columns A through P and in column C I have dates in the format
YYYYMMDD and I need the format MMDDYYYY. I only have one worksheet in this
file. Can anyone help me with this? susan
 
M

Mike H

Hi,

Select column C dates then

Format|Cells - Custom

enter a custom format of MMDDYYYY

Mike
 
I

ILoveMyCorgi

Thanks. I tried that and the result is ######### all the way across the
fields no matter how much I shrink or stretch that column.
 
R

Rick Rothstein

When you say you have "dates in the format YYYYMMDD", do you mean you have *real* date values in cells that have been Cell Formatted to look like "YYYYMMDD", or do you mean you have "YYYYMMDD" looking text strings (that is, not *real* dates)? If you have *real* dates, then just use cell formatting to make them look like you want. If they are just text strings, then try this formula...

=TEXT(--TEXT(A1,"0000-00-00"),"mmddyyyy")
 
I

ILoveMyCorgi

Thanks! That worked beautifully. I had actually real dates that were
extracted from a database and I needed to import the data into a database
that will only accept the MMDDYYYY format. Thanks so much for helping me.
Susan
 

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

I need to convert a series of DOB's from yyyymmdd to mmddyyyy 1
Excel date format YYYYMMDD 1
Convert WAV to MP3 4
Date Conversion 2
Open txt file without changing date 1
Converting Text to Date 3
Date Conversion 6
Convert Date-as-Text 3

Top