| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Format
I have dates shown as:
A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
Hi Graham
One way =--(B1&"/"&C1&"/"&A1) -- Regards Roger Govier Graham wrote: I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
=DATE(A1,MONTH(C1&1),B1)
"Graham" wrote: I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
Another...
=--(C1&B1&", "&A1) "Graham" wrote: I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Format
Another one:
=--(B1&C1&A1) And give the cell with the formula the format you like (dd/mm/yyyy) Graham wrote: I have dates shown as: A B C 2010 5 Mar I need them to change to 1 cell in the format 05/03/2010 Can anyone help?? ThanKS Graham -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| permanent conversion of 1904 date format to 1900 date format | Excel Worksheet Functions | |||
| How do I convert dd/mm/yy date format to yyddd Julian 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 | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
