A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel automatically formats data as dates when pasting



 
 
Thread Tools Display Modes
  #1  
Old October 15th, 2004, 07:25 PM
Alistair
external usenet poster
 
Posts: n/a
Default Excel automatically formats data as dates when pasting

Hi

I frequently copy and past data from a particular website
and paste it into Excel 2000. The data is in the form x-y,
where both x and y are integers. Unfortunately, depending
on the values of x and y, Excel automatically formates the
pasted data as dates. How can I stop this?

I know I can use the importing function to pull data in
from a web page and via that I can switch off the
automatic formatting. However, the webpage concerned is
password protected so this method doesn't work.

Please help as this is driving me nuts

Cheers

Alistair
  #2  
Old October 15th, 2004, 11:14 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

Any chance you could copy|paste into notepad. Save that as a .txt file and then
file|open the text file in excel.

Then you can specify Text for those fields.

Alistair wrote:

Hi

I frequently copy and past data from a particular website
and paste it into Excel 2000. The data is in the form x-y,
where both x and y are integers. Unfortunately, depending
on the values of x and y, Excel automatically formates the
pasted data as dates. How can I stop this?

I know I can use the importing function to pull data in
from a web page and via that I can switch off the
automatic formatting. However, the webpage concerned is
password protected so this method doesn't work.

Please help as this is driving me nuts

Cheers

Alistair


--

Dave Peterson

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I automatically repeat data in several excel workbooks sjhartley99 General Discussion 2 October 25th, 2004 03:57 PM
Excel Worksheets Richard General Discussion 2 July 8th, 2004 04:34 AM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM
Pasting data into a cell - and Excel changes the format automatic apply of cell format Worksheet Functions 2 April 21st, 2004 09:31 PM
Merging Excel Data into Word Document Debra Dalgleish Worksheet Functions 1 February 16th, 2004 01:15 AM


All times are GMT +1. The time now is 01:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.