Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a text file containing lines
3-01 3-02 3-03 etc On copy/pasting these into an empty column (in Excel 2002) they were displayed as 03-Jan 03-Feb 03-Mar etc First, I don't really understand why. That column was not formatted for dates. More important, I don't see why specifying General or Text doesn't now get them displayed correctly? Any advice would be appreciated please. -- Terry, East Grinstead, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
wrong result Paste within same row while filtered condition applie | New Users to Excel | |||
Strange cut and paste result between worksheets | Excel Programming | |||
how do you match data and paste result in a perticular cell? | Excel Worksheet Functions | |||
Macro to look for where vLookup has a result then paste value | Excel Discussion (Misc queries) | |||
Copy Paste of Formula Produces Incorrect Result | Excel Discussion (Misc queries) |