| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with date conversion - yyyymmdd to dd/mm/yyyy
Please can someone tell me how I can convert a date of format 20051212 to 12/12/2005? Thanks in advance. -- markperry ------------------------------------------------------------------------ markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593 View this thread: http://www.excelforum.com/showthread...hreadid=503334 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with date conversion - yyyymmdd to dd/mm/yyyy
Hi markperry
If it`s columns, select columns and change it on the format, cells meny. Regards yngve |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with date conversion - yyyymmdd to dd/mm/yyyy
If it is stored as a text item then assuming data is in cell A1 - in a
suitable cell: =right(a1,2)&"/"&mid(a1,5,2)&"/"&left(a1,4) will put it into the order that you want. "markperry" wrote: Please can someone tell me how I can convert a date of format 20051212 to 12/12/2005? Thanks in advance. -- markperry ------------------------------------------------------------------------ markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593 View this thread: http://www.excelforum.com/showthread...hreadid=503334 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with date conversion - yyyymmdd to dd/mm/yyyy
This works perfectly - much appreciated. -- markperry ------------------------------------------------------------------------ markperry's Profile: http://www.excelforum.com/member.php...o&userid=27593 View this thread: http://www.excelforum.com/showthread...hreadid=503334 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert date format yyyymmdd to mm/dd/yyyy | Excel Worksheet Functions | |||
| how do I change the date format from yyyymmdd to mm/dd/yyyy | Excel Worksheet Functions | |||
| Need macro to change date from yyyymmdd format to mm/dd/yyyy forma | Excel Programming | |||
| m/d/yyyy h:mm date conversion to yyyymmdd ??? | Excel Programming | |||
| date conversion from m/d/yyyy to yyyymmdd | Excel Programming | |||
Linear Mode
