| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba excel - converting Number to Date
Hi all, I have a list of numbers, and I need to sort them as date. fo example: 281100 == must be 28/november/2000 110303 == must be 11/march/2003 271004 == must be 27/october/2004 I am trying to convert these numbers into dates, and sorting them, bu getting errors in the translation, for example, if I try NewDate=CDate(110303), I get 30/December/2201 instead o 11/November/2003 Could anybody help, please? Thanks in advance, Aldo -- ajliak ----------------------------------------------------------------------- ajliaks's Profile: http://www.excelforum.com/member.php...nfo&userid=819 View this thread: http://www.excelforum.com/showthread.php?threadid=27278 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Number to Date | Excel Discussion (Misc queries) | |||
| Converting a number to a date | Excel Discussion (Misc queries) | |||
| converting date to number | Excel Worksheet Functions | |||
| converting 8-digit number to date | Excel Discussion (Misc queries) | |||
| converting a number to a date | Excel Programming | |||
![ajliaks[_42_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
