| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
avoid turning #/## into date when pasting or parsing
I import race data from web sites. I don't want 1st out of 51 which starts
as 1/51 to turn into Jan-51 (which is something like 18600) and I don't want 1st out of 5 to turn into May 1 of the current year. Past special text will give me a line of text preserving the 1/51 or 1/5, but parsing it into columns gives jan-51 and may 1 (as well as putting stuff in the wrong columns due to extra spaces in city names). -- jimtherunner |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to avoid pasting blanks ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to avoid pasting incremental refrences ? | Excel Discussion (Misc queries) | |||
| parsing on a date string pulled from a database. | Excel Discussion (Misc queries) | |||
| Date/Time parsing and calculation | Excel Discussion (Misc queries) | |||
| parsing a date field | Excel Discussion (Misc queries) | |||
Threaded Mode
