DISABLE AUTO CONVERT FOR GOD'S SAKE!

[Wigi]

http://www.microsoft.com/communitie...14e-9881-2ba33de8be2f&lang=en&cr=US&sloc=&p=1

Do not multipost FOR GOD'S SAKE!

 

[John3005]

So what thats ur answer? Ehhh boy go back to notepad forum.

----- Original Message -----
From: "Wigi" <[email protected]>
Newsgroups: microsoft.public.excel
Sent: Thursday, July 24, 2008 10:02 PM
Subject: RE: DISABLE AUTO CONVERT FOR GOD'S SAKE!

 

[John3005]

When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!

 

[Peo Sjoblom]

Nice. I am sure you will get a lot of help with that attitude

--


Regards,


Peo Sjoblom

 

[John3005]

Lol at least it is funny... there is seems to be no solution anyway.

 

[Wigi]

Well, the problem is: PEBCAC.

 

[John3005]

On your side.

Well, the problem is: PEBCAC.

 

[Gord Dibben]

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

 

[Harlan Grove]

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?