| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
parsing a date field
I have data that was imported from another system (don't know what system). The date field shows as 01-01-2005. I need to split the field so that the month is one cell and the year in another (don't need day). I tried the usual right(a1,2) type command, but I get 53 returned. I tried to first convert the date to text, but then I get the full five digit date. I'm sure that there is an easy solution to this, but I don't know what it is and couldn't locate it in the board archives. Thank you!! Carrie -- carriex3 ------------------------------------------------------------------------ carriex3's Profile: http://www.excelforum.com/member.php...o&userid=36997 View this thread: http://www.excelforum.com/showthread...hreadid=567205 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| How do I format date field in footer? | New Users to Excel | |||
| Date & Time Field | Excel Discussion (Misc queries) | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| in vba for access how do i get the day of the week for a date field? | Excel Worksheet Functions | |||
Threaded Mode
