auto correct numbers with dates

H

Henrik

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 "paste
special" 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
 
H

Henrik

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...

"Peo Sjoblom" skrev:
 
Top