Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henrik
 
Posts: n/a
Default auto correct numbers with dates

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default auto correct numbers with dates

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Henrik" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henrik
 
Posts: n/a
Default auto correct numbers with dates

I am sorry...I dont know what a webquery is?

"Peo Sjoblom" skrev:

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Henrik" wrote in message
...
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




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default auto correct numbers with dates

Dataimport external data, new web query

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Henrik" wrote in message
...
I am sorry...I dont know what a webquery is?

"Peo Sjoblom" skrev:

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Henrik" wrote in message
...
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






  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Henrik
 
Posts: n/a
Default auto correct numbers with dates

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:

Dataimport external data, new web query

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Henrik" wrote in message
...
I am sorry...I dont know what a webquery is?

"Peo Sjoblom" skrev:

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Henrik" wrote in message
...
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel auto filtering to find a range of dates in a list Candy Excel Discussion (Misc queries) 2 January 31st 06 03:32 PM
prevent converting numbers with hyphens to dates Mike Excel Discussion (Misc queries) 5 January 27th 06 09:41 PM
Auto generate numbers in decending order in a column JsJ New Users to Excel 2 November 9th 05 04:28 PM
Auto convert an alphanumeric string (CIS9638S) to numbers only? Gary L Brown Excel Worksheet Functions 1 September 7th 05 01:17 AM
How do I stop auto converting Text(Inventory#) to Dates DavidB Excel Discussion (Misc queries) 1 September 2nd 05 05:14 PM


All times are GMT +1. The time now is 08:42 PM.

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

About Us

"It's about Microsoft Excel"