DISABLE AUTO CONVERT FOR GOD'S SAKE!

  • Thread starter Thread starter Wigi
  • Start date Start date
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!
 
When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!
 
Nice. I am sure you will get a lot of help with that attitude

--


Regards,


Peo Sjoblom
 
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
 
John3005 said:
When you copy paste in excel 2003 it auto converts to date or number etc i
dont want this. HELP!
Click to expand...

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?
 
Back
Top