Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...
MS Office Forum / Excel / General Excel Questions / May 2008

Tip: Looking for answers? Try searching our database.

Combining date to one cell with uniform results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gail - 29 May 2008 19:37 GMT
I am trying to remove the / from a date column and have the results formated
equally. For instance,  the original column has various dates fromatted
different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
dates displayed with 6 numbers 03081955 and 10051985
Any help would be appreciated.
Reply to this Message
muddan madhu - 29 May 2008 20:04 GMT
suppose A1 u have 3/08/1955, put  B1 =DAY(A1)&MONTH(A1)&YEAR(A1)

> I am trying to remove the / from a date column and have the results formated
> equally. For instance,  the original column has various dates fromatted
> different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
> dates displayed with 6 numbers 03081955 and 10051985
> Any help would be appreciated.
Reply to this Message
dhstein - 29 May 2008 20:07 GMT
=IF(MONTH(G24)<10,"0"&MONTH(G24),MONTH(G24))&IF(DAY(G24)<10,"0"&DAY(G24),DAY(G24))&YEAR(G24)

> I am trying to remove the / from a date column and have the results formated
> equally. For instance,  the original column has various dates fromatted
> different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
> dates displayed with 6 numbers 03081955 and 10051985
> Any help would be appreciated.
Reply to this Message
David Biddulph - 29 May 2008 20:58 GMT
If they are real dates, not text, format the cells as ddmmyyyy or use
=TEXT(A2,"ddmmyyyy")
--
David Biddulph

>I am trying to remove the / from a date column and have the results
>formated
> equally. For instance,  the original column has various dates fromatted
> different ways such as, 3/8/1955 or 10/05/1985. I need a column with the
> dates displayed with 6 numbers 03081955 and 10051985
> Any help would be appreciated.
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.