| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date number separation
Hi this might be easy for you guys...
In column A I got a date in the 1st row, number in the 2nd, date in the 3rd, number in the 4th and so on up to row 200. I want dates only in column A and numbers only in column B (the number that is directly below each date). Also no blank cells in between the rows. Of course i could copy paste everything and then manually delete every second row but that would take forwever. any suggestions? thanks S. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Number of Days in a Date Range | Excel Discussion (Misc queries) | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
| How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Threaded Mode
