software

I am trying to copy a text from a webpage into excel. The problem is that
some of the things I am trying to copy are numbers like 16-1 excel then
wantsto format it to a date so in excel 16-1 turns up like 16 jan. I know
that i can format the cell to text instead of dates... but I am going to copy
past hundreds of times and I therefor want to preformat the cells... cause
even if I format the cell to a text cell before I paste my numbers it is
still returning it as a date. I have also tried to use the command quot;paste
specialquot; but then my text doen not appears in the different columns that I
want. Is there some to lock the cells from reformating when I am pasting in
them or even better...can I turn this autocorrect to dates function off?

br
Henrik

Is there anyway you can do a web query instead? If so there is an option to
turn off date recognition--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Henrikquot; gt; wrote in message
...
gt;I am trying to copy a text from a webpage into excel. The problem is that
gt; some of the things I am trying to copy are numbers like 16-1 excel then
gt; wantsto format it to a date so in excel 16-1 turns up like 16 jan. I know
gt; that i can format the cell to text instead of dates... but I am going to
gt; copy
gt; past hundreds of times and I therefor want to preformat the cells... cause
gt; even if I format the cell to a text cell before I paste my numbers it is
gt; still returning it as a date. I have also tried to use the command quot;paste
gt; specialquot; but then my text doen not appears in the different columns that I
gt; want. Is there some to lock the cells from reformating when I am pasting
gt; in
gt; them or even better...can I turn this autocorrect to dates function off?
gt;
gt; br
gt; Henrik
I am sorry...I dont know what a webquery is?

quot;Peo Sjoblomquot; skrev:

gt; Is there anyway you can do a web query instead? If so there is an option to
gt; turn off date recognition
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Henrikquot; gt; wrote in message
gt; ...
gt; gt;I am trying to copy a text from a webpage into excel. The problem is that
gt; gt; some of the things I am trying to copy are numbers like 16-1 excel then
gt; gt; wantsto format it to a date so in excel 16-1 turns up like 16 jan. I know
gt; gt; that i can format the cell to text instead of dates... but I am going to
gt; gt; copy
gt; gt; past hundreds of times and I therefor want to preformat the cells... cause
gt; gt; even if I format the cell to a text cell before I paste my numbers it is
gt; gt; still returning it as a date. I have also tried to use the command quot;paste
gt; gt; specialquot; but then my text doen not appears in the different columns that I
gt; gt; want. Is there some to lock the cells from reformating when I am pasting
gt; gt; in
gt; gt; them or even better...can I turn this autocorrect to dates function off?
gt; gt;
gt; gt; br
gt; gt; Henrik
gt;
gt;
gt;

Datagt;import external data, new web query

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Henrikquot; gt; wrote in message
...
gt;I am sorry...I dont know what a webquery is?
gt;
gt; quot;Peo Sjoblomquot; skrev:
gt;
gt;gt; Is there anyway you can do a web query instead? If so there is an option
gt;gt; to
gt;gt; turn off date recognition
gt;gt;
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Henrikquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am trying to copy a text from a webpage into excel. The problem is
gt;gt; gt;that
gt;gt; gt; some of the things I am trying to copy are numbers like 16-1 excel then
gt;gt; gt; wantsto format it to a date so in excel 16-1 turns up like 16 jan. I
gt;gt; gt; know
gt;gt; gt; that i can format the cell to text instead of dates... but I am going
gt;gt; gt; to
gt;gt; gt; copy
gt;gt; gt; past hundreds of times and I therefor want to preformat the cells...
gt;gt; gt; cause
gt;gt; gt; even if I format the cell to a text cell before I paste my numbers it
gt;gt; gt; is
gt;gt; gt; still returning it as a date. I have also tried to use the command
gt;gt; gt; quot;paste
gt;gt; gt; specialquot; but then my text doen not appears in the different columns
gt;gt; gt; that I
gt;gt; gt; want. Is there some to lock the cells from reformating when I am
gt;gt; gt; pasting
gt;gt; gt; in
gt;gt; gt; them or even better...can I turn this autocorrect to dates function
gt;gt; gt; off?
gt;gt; gt;
gt;gt; gt; br
gt;gt; gt; Henrik
gt;gt;
gt;gt;
gt;gt;
have tried that now and its actually working...too bad its a lot more time
consuming than just copy paste from a website... i actually wants some of the
text that isnt in a list too...

but thanks anyway!

swede i guess? me too...

quot;Peo Sjoblomquot; skrev:

gt; Datagt;import external data, new web query
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Henrikquot; gt; wrote in message
gt; ...
gt; gt;I am sorry...I dont know what a webquery is?
gt; gt;
gt; gt; quot;Peo Sjoblomquot; skrev:
gt; gt;
gt; gt;gt; Is there anyway you can do a web query instead? If so there is an option
gt; gt;gt; to
gt; gt;gt; turn off date recognition
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; nwexcelsolutions.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Henrikquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I am trying to copy a text from a webpage into excel. The problem is
gt; gt;gt; gt;that
gt; gt;gt; gt; some of the things I am trying to copy are numbers like 16-1 excel then
gt; gt;gt; gt; wantsto format it to a date so in excel 16-1 turns up like 16 jan. I
gt; gt;gt; gt; know
gt; gt;gt; gt; that i can format the cell to text instead of dates... but I am going
gt; gt;gt; gt; to
gt; gt;gt; gt; copy
gt; gt;gt; gt; past hundreds of times and I therefor want to preformat the cells...
gt; gt;gt; gt; cause
gt; gt;gt; gt; even if I format the cell to a text cell before I paste my numbers it
gt; gt;gt; gt; is
gt; gt;gt; gt; still returning it as a date. I have also tried to use the command
gt; gt;gt; gt; quot;paste
gt; gt;gt; gt; specialquot; but then my text doen not appears in the different columns
gt; gt;gt; gt; that I
gt; gt;gt; gt; want. Is there some to lock the cells from reformating when I am
gt; gt;gt; gt; pasting
gt; gt;gt; gt; in
gt; gt;gt; gt; them or even better...can I turn this autocorrect to dates function
gt; gt;gt; gt; off?
gt; gt;gt; gt;
gt; gt;gt; gt; br
gt; gt;gt; gt; Henrik
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;