software

I have copied and pasted numbers from a source on the internet into a column.
Some appear to be formatted as numbers, some are formatted as text. When I
reformat using Data and Text to Columns to organize them and get rid of extra
spaces, any multiple numbers less than 31 with a dash in between them change
to dates, and then if I reformat cells to text it changes the dates to a five
digit number. Here is one example... 4-27 changes to Apr 27, then to 38824.

I have thousands of these. I've been entering '4-27 to keep the number as
text. This takes forever. There must be an easier way to do the entire
column. Please help.

Hi

Before you paste the data, format the column as Text. Once you have done
this, you can use Paste Special / Values.

Hope this helps.
Andy.

quot;Julie Willemsquot; lt;Julie gt; wrote in message
...
gt;I have copied and pasted numbers from a source on the internet into a
gt;column.
gt; Some appear to be formatted as numbers, some are formatted as text. When I
gt; reformat using Data and Text to Columns to organize them and get rid of
gt; extra
gt; spaces, any multiple numbers less than 31 with a dash in between them
gt; change
gt; to dates, and then if I reformat cells to text it changes the dates to a
gt; five
gt; digit number. Here is one example... 4-27 changes to Apr 27, then to
gt; 38824.
gt;
gt; I have thousands of these. I've been entering '4-27 to keep the number as
gt; text. This takes forever. There must be an easier way to do the entire
gt; column. Please help.
Julie

When in the Text to Columns dialog there is an option under quot;Column data formatquot;
to choose quot;textquot;.

Try that on the columns with the 4-27 etc.

Alternative...........Datagt;Import External Datagt;New Web Query.

You will have the options to pick the data you want to import and

Click on the Options button and checkmark Formattinggt;None Import
blocks into columns and........... Disable Date Recognition.........Gord Dibben MS Excel MVP

On Tue, 17 Jan 2006 03:51:02 -0800, quot;Julie Willemsquot; lt;Julie
gt; wrote:

gt;I have copied and pasted numbers from a source on the internet into a column.
gt;Some appear to be formatted as numbers, some are formatted as text. When I
gt;reformat using Data and Text to Columns to organize them and get rid of extra
gt;spaces, any multiple numbers less than 31 with a dash in between them change
gt;to dates, and then if I reformat cells to text it changes the dates to a five
gt;digit number. Here is one example... 4-27 changes to Apr 27, then to 38824.
gt;
gt;I have thousands of these. I've been entering '4-27 to keep the number as
gt;text. This takes forever. There must be an easier way to do the entire
gt;column. Please help.