| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date spilt into four cells
Now I have to go from date into four cells... I have: A5: 09/25/04 I need: D11: 0 E11: 9 G11: 2 H11: 5 J11: 0 K11: 4 My problem: Instead of pulling the month as 09, it is pulling 38. 09/25/04 = 38255 What I'm using: =MID($AP$5*100,1,1)+0 Is there a macro or formula to keep the numbers as a date instead o changing them back to a number -- hyyft ----------------------------------------------------------------------- hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318 View this thread: http://www.excelforum.com/showthread.php?threadid=26557 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clarification - how to automatically update cells with a date and date range | Excel Discussion (Misc queries) | |||
| Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y | Excel Discussion (Misc queries) | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Spilt Entire Name into Two columns | Excel Discussion (Misc queries) | |||
| Spilt value and currency | Excel Discussion (Misc queries) | |||
![hyyfte[_25_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
