| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining date to one cell with uniform results
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining date to one cell with uniform results
suppose A1 u have 3/08/1955, put B1 =DAY(A1)&MONTH(A1)&YEAR(A1)
On May 29, 11:37*pm, Gail wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining date to one cell with uniform results
=IF(MONTH(G24)<10,"0"&MONTH(G24),MONTH(G24))&IF(DA Y(G24)<10,"0"&DAY(G24),DAY(G24))&YEAR(G24)
"Gail" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining date to one cell with uniform results
If they are real dates, not text, format the cells as ddmmyyyy or use
=TEXT(A2,"ddmmyyyy") -- David Biddulph "Gail" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining date and time into one cell | Excel Discussion (Misc queries) | |||
| Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
| how can i make a uniform timetable? | Excel Discussion (Misc queries) | |||
| Combining formulas and results HELP!! | New Users to Excel | |||
| Concatenate and make uniform | Excel Worksheet Functions | |||
Hybrid Mode
