Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date to different format
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date to different format
Hi,
Select column C dates then Format|Cells - Custom enter a custom format of MMDDYYYY Mike "ILoveMyCorgi" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date to different format
Thanks. I tried that and the result is ######### all the way across the
fields no matter how much I shrink or stretch that column. "ILoveMyCorgi" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date to different format
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") -- Rick (MVP - Excel) "ILoveMyCorgi" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
convert date to different format
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 "Rick Rothstein" wrote: 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") -- Rick (MVP - Excel) "ILoveMyCorgi" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert dd/mm/yy date format to yyddd Julian date format | Excel Worksheet Functions | |||
Convert european foreign date format to US date format | Excel Worksheet Functions | |||
convert serial date format to normal date format | Excel Discussion (Misc queries) | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming |