Date Format

[Guest]

Hi
I would like to copy-paste text from a website to Excel. The problem is that it keeps changing the text into a date. For instance, 1/8 changes to 8-JAN. How do I turn this off

Thanks in advanc
BB

 

[Jim Macklin]

Try an Excel newsgroup if this doesn't work. Format the
field in Excel as general data.


--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.


| Hi,
| I would like to copy-paste text from a website to Excel.
The problem is that it keeps changing the text into a date.
For instance, 1/8 changes to 8-JAN. How do I turn this off?
|
| Thanks in advance
| BB

 

[Tom Porterfield]

Hi,
I would like to copy-paste text from a website to Excel. The problem
is that it keeps changing the text into a date. For instance, 1/8
changes to 8-JAN. How do I turn this off?

With the cell or entire row/column of cells selected, click on the Excel
menu Format and then Cells. Change the format to Text. Note that you need
to do this before entering the value as Excel has already interpretted
entered data and converted it to Date.
--
Tom Porterfield
MS-MVP MCE
http://support.telop.org

Please post all follow-ups to the newsgroup only.