|  | DISABLE AUTO CONVERT FOR GOD'S SAKE! | | |
| | | John3005 |  |
|  Posted: Thu Jul 24, 2008 5:41 pm Post subject: DISABLE AUTO CONVERT FOR GOD'S SAKE! |  |
When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP! |
| |
| | | Wigi | |
| | Posted: Thu Jul 24, 2008 5:41 pm Post subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
LINK
Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
| Quote: | When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!
|
|
| |
| | | John3005 | |
| | Posted: Thu Jul 24, 2008 5:41 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
So what thats ur answer? Ehhh boy go back to notepad forum.
----- Original Message -----
From: "Wigi" <Wigi@discussions.microsoft.com>
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!
| Quote: | Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
When you copy paste in excel 2003 it auto converts to date or number etc
i
dont want this. HELP!
|
|
| |
| | | Peo Sjoblom | |
| | Posted: Thu Jul 24, 2008 5:45 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
Nice. I am sure you will get a lot of help with that attitude
--
Regards,
Peo Sjoblom
"John3005" <john@mail.com> wrote in message
news:%232W89Mc7IHA.4988@TK2MSFTNGP04.phx.gbl...
| Quote: | So what thats ur answer? Ehhh boy go back to notepad forum.
----- Original Message -----
From: "Wigi" <Wigi@discussions.microsoft.com
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!
Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
When you copy paste in excel 2003 it auto converts to date or number etc
i
dont want this. HELP!
|
|
| |
| | | John3005 | |
| | Posted: Thu Jul 24, 2008 6:03 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
Lol at least it is funny... there is seems to be no solution anyway.
"Peo Sjoblom" <peo.sjoblom@mvps.org> wrote in message
news:%23JjvaXc7IHA.5164@TK2MSFTNGP02.phx.gbl...
| Quote: | Nice. I am sure you will get a lot of help with that attitude
--
Regards,
Peo Sjoblom
"John3005" <john@mail.com> wrote in message
news:%232W89Mc7IHA.4988@TK2MSFTNGP04.phx.gbl...
So what thats ur answer? Ehhh boy go back to notepad forum.
----- Original Message -----
From: "Wigi" <Wigi@discussions.microsoft.com
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!
Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
When you copy paste in excel 2003 it auto converts to date or number
etc i
dont want this. HELP!
|
|
| |
| | | Wigi | |
| | Posted: Thu Jul 24, 2008 6:29 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
Well, the problem is: PEBCAC.
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
| Quote: | Lol at least it is funny... there is seems to be no solution anyway.
"Peo Sjoblom" <peo.sjoblom@mvps.org> wrote in message
news:%23JjvaXc7IHA.5164@TK2MSFTNGP02.phx.gbl...
Nice. I am sure you will get a lot of help with that attitude
--
Regards,
Peo Sjoblom
"John3005" <john@mail.com> wrote in message
news:%232W89Mc7IHA.4988@TK2MSFTNGP04.phx.gbl...
So what thats ur answer? Ehhh boy go back to notepad forum.
----- Original Message -----
From: "Wigi" <Wigi@discussions.microsoft.com
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!
Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
When you copy paste in excel 2003 it auto converts to date or number
etc i
dont want this. HELP!
|
|
| |
| | | John3005 | |
| | Posted: Thu Jul 24, 2008 6:43 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
| |  | |
On your side.
"Wigi" <Wigi@discussions.microsoft.com> wrote in message
news:ADDF86CF-68D6-4AF3-B48D-4C7B014204BA@microsoft.com...
| Quote: | Well, the problem is: PEBCAC.
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
Lol at least it is funny... there is seems to be no solution anyway.
"Peo Sjoblom" <peo.sjoblom@mvps.org> wrote in message
news:%23JjvaXc7IHA.5164@TK2MSFTNGP02.phx.gbl...
Nice. I am sure you will get a lot of help with that attitude
--
Regards,
Peo Sjoblom
"John3005" <john@mail.com> wrote in message
news:%232W89Mc7IHA.4988@TK2MSFTNGP04.phx.gbl...
So what thats ur answer? Ehhh boy go back to notepad forum.
----- Original Message -----
From: "Wigi" <Wigi@discussions.microsoft.com
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!
Do not multipost FOR GOD'S SAKE!
--
Wigi
LINK = Excel/VBA, soccer and music
"John3005" wrote:
When you copy paste in excel 2003 it auto converts to date or number
etc i
dont want this. HELP!
|
|
| |
| | | Gord Dibben | |
| | Posted: Thu Jul 24, 2008 7:29 pm Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
Go the extra step and paste your copy into Notepad and save as a *.txt file.
Open that in Excel and you will get the Text Import Wizard wherein you can
designate delimiter and column data format.
Gord Dibben MS Excel MVP
On Thu, 24 Jul 2008 22:41:22 +0300, "John3005" <john@mail.com> wrote:
| Quote: | When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!
|
|
| |
| | | Harlan Grove | |
| | Posted: Fri Jul 25, 2008 7:50 am Post subject: Re: DISABLE AUTO CONVERT FOR GOD'S SAKE! | |
"John3005" <j...@mail.com> wrote...
| Quote: | When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!
|
I saw your example of 6.30 being converted to June 30. I could
replicate this, but it took setting my decimal point character to
comma ( , ) and my short date format to m.d. If your locale's decimal
point character is a comma and the date separator (between year, month
and day) is a period, then pasting data in US locale number formats is
going to lead to trouble. OTOH, if your locale's decimal point
character is a period but Excel is still converting 6.30 to June 30,
then either Excel is seriously screwed up on your machine, or there
could be some extra text getting pasted.
Could you provide an EXACT sample of the troublesome data you're
trying to paste into Excel, or better yet a url to the web site? |
| |
|
|
