Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable Date Recognition?
Is there any way within Excel whereby I can disable date recognition? I
often copy data from an HTML page and paste it into Excel. Even if I select 'paste special'/'text', I still have problem with data like 10-12, and 5/6. I can overcome this by importing data/new web query/options/disable date recognition, but it appears to be a bit long-winded compared to copy/paste. Thanks. |
#2
|
|||
|
|||
If you select (highlight) the columns into which you are pasting, and Format Cells, set format to TEXT, and then Paste Special, Text your cricket scores should remain intact. Saxman Wrote: Is there any way within Excel whereby I can disable date recognition? I often copy data from an HTML page and paste it into Excel. Even if I select 'paste special'/'text', I still have problem with data like 10-12, and 5/6. I can overcome this by importing data/new web query/options/disable date recognition, but it appears to be a bit long-winded compared to copy/paste. Thanks. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=392458 |
#3
|
|||
|
|||
Try formatting the cells the cells as text before pasting.
-- Gary's Student "Saxman" wrote: Is there any way within Excel whereby I can disable date recognition? I often copy data from an HTML page and paste it into Excel. Even if I select 'paste special'/'text', I still have problem with data like 10-12, and 5/6. I can overcome this by importing data/new web query/options/disable date recognition, but it appears to be a bit long-winded compared to copy/paste. Thanks. |
#4
|
|||
|
|||
Bryan Hessey wrote:
If you select (highlight) the columns into which you are pasting, and Format Cells, set format to TEXT, and then Paste Special, Text your cricket scores should remain intact. I tried this yesterday without success and today it works fine! I must have been doing something wrong! Thanks. |
Reply |
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 | |||
Disable Date Recognition | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
How do I disable automatic date formatting in excel? | Excel Discussion (Misc queries) | |||
Disable automatic date conversion feature | Excel Worksheet Functions |