Combining date to one cell with uniform results

  • Thread starter Thread starter Gail
  • Start date Start date
G

Gail

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.
 
=IF(MONTH(G24)<10,"0"&MONTH(G24),MONTH(G24))&IF(DAY(G24)<10,"0"&DAY(G24),DAY(G24))&YEAR(G24)
 
You must log in or register to reply here.

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

format text to date results in ############## 4
Formatting Text to Numbers for Dates 1
adding text according to col with equal date 2
Formatting Text to Numbers for Dates 2
Highlighting cells with specified dates 2
Problems with COUNTIF formulae 2
Remove date format? 3
Counting Cells with Multiple Range Criteria (Excel 2003) 7

Back
Top