| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISABLE AUTO CONVERT FOR GOD'S SAKE!
Click TOOLS in the menu and then select OPTIONS. In the OPTIONS dialog box,
click the EDIT tab and on the right is a series of check boxes, the 3rd one is SHOW PASTE OPTIONS BUTTONS. Click this check box to turn it on, click OK to exit the dialog box. Now when you paste data into a worksheet the PASTE OPTIONS button appears. Clicking this button gives you a menu of what and how you want to paste. -- Kevin Backmann "John3005" wrote: When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISABLE AUTO CONVERT FOR GOD'S SAKE!
It does not help because its already on and its just lets u chose u want
destination formating or source, there is no option to paste "as-is" it converts to date anyway when its just numbers that i want to past or can i past as text somehow? Converting cells to text and then pasting does not help it still converts to date format. "Kevin B" wrote in message ... Click TOOLS in the menu and then select OPTIONS. In the OPTIONS dialog box, click the EDIT tab and on the right is a series of check boxes, the 3rd one is SHOW PASTE OPTIONS BUTTONS. Click this check box to turn it on, click OK to exit the dialog box. Now when you paste data into a worksheet the PASTE OPTIONS button appears. Clicking this button gives you a menu of what and how you want to paste. -- Kevin Backmann "John3005" wrote: When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISABLE AUTO CONVERT FOR GOD'S SAKE!
Are you copying within XL or are you copying from an external application.
What is the format of the data you are copying. An example and a few more details would really help... -- HTH... Jim Thomlinson "John3005" wrote: It does not help because its already on and its just lets u chose u want destination formating or source, there is no option to paste "as-is" it converts to date anyway when its just numbers that i want to past or can i past as text somehow? Converting cells to text and then pasting does not help it still converts to date format. "Kevin B" wrote in message ... Click TOOLS in the menu and then select OPTIONS. In the OPTIONS dialog box, click the EDIT tab and on the right is a series of check boxes, the 3rd one is SHOW PASTE OPTIONS BUTTONS. Click this check box to turn it on, click OK to exit the dialog box. Now when you paste data into a worksheet the PASTE OPTIONS button appears. Clicking this button gives you a menu of what and how you want to paste. -- Kevin Backmann "John3005" wrote: When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISABLE AUTO CONVERT FOR GOD'S SAKE!
Copying table from internet explorer and pasting to excel. I like it quick
and easy no need to use import menu and waste time, but it does mees it up sometimes with auto convertion to other format. e.g. type "6.30" in notepad and copy paste to excel it will convert to "june.30". ----- Original Message ----- From: "Jim Thomlinson" Newsgroups: microsoft.public.excel.misc Sent: Thursday, July 24, 2008 10:49 PM Subject: DISABLE AUTO CONVERT FOR GOD'S SAKE! Are you copying within XL or are you copying from an external application. What is the format of the data you are copying. An example and a few more details would really help... -- HTH... Jim Thomlinson "John3005" wrote: It does not help because its already on and its just lets u chose u want destination formating or source, there is no option to paste "as-is" it converts to date anyway when its just numbers that i want to past or can i past as text somehow? Converting cells to text and then pasting does not help it still converts to date format. "Kevin B" wrote in message ... Click TOOLS in the menu and then select OPTIONS. In the OPTIONS dialog box, click the EDIT tab and on the right is a series of check boxes, the 3rd one is SHOW PASTE OPTIONS BUTTONS. Click this check box to turn it on, click OK to exit the dialog box. Now when you paste data into a worksheet the PASTE OPTIONS button appears. Clicking this button gives you a menu of what and how you want to paste. -- Kevin Backmann "John3005" wrote: When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
DISABLE AUTO CONVERT FOR GOD'S SAKE!
e.g. type "6.30" in notepad and copy paste to excel it will convert to
"june.30". When I do that I get 6.3. Sometimes this helps... When you go to paste into Excel, select the destination then right click and use Paste Special. You should have a few choices available: HTML, Unicode text, text. -- Biff Microsoft Excel MVP "John3005" wrote in message ... Copying table from internet explorer and pasting to excel. I like it quick and easy no need to use import menu and waste time, but it does mees it up sometimes with auto convertion to other format. e.g. type "6.30" in notepad and copy paste to excel it will convert to "june.30". ----- Original Message ----- From: "Jim Thomlinson" Newsgroups: microsoft.public.excel.misc Sent: Thursday, July 24, 2008 10:49 PM Subject: DISABLE AUTO CONVERT FOR GOD'S SAKE! Are you copying within XL or are you copying from an external application. What is the format of the data you are copying. An example and a few more details would really help... -- HTH... Jim Thomlinson "John3005" wrote: It does not help because its already on and its just lets u chose u want destination formating or source, there is no option to paste "as-is" it converts to date anyway when its just numbers that i want to past or can i past as text somehow? Converting cells to text and then pasting does not help it still converts to date format. "Kevin B" wrote in message ... Click TOOLS in the menu and then select OPTIONS. In the OPTIONS dialog box, click the EDIT tab and on the right is a series of check boxes, the 3rd one is SHOW PASTE OPTIONS BUTTONS. Click this check box to turn it on, click OK to exit the dialog box. Now when you paste data into a worksheet the PASTE OPTIONS button appears. Clicking this button gives you a menu of what and how you want to paste. -- Kevin Backmann "John3005" wrote: When you copy paste in excel 2003 it auto converts to date or number etc i dont want this. HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does one disable Auto-Formatting of dates? | Excel Discussion (Misc queries) | |||
| Disable Auto save on Right Click | Excel Discussion (Misc queries) | |||
| Pivoting for the sake of look | Charts and Charting in Excel | |||
| Can I disable auto formula update? | New Users to Excel | |||
| Looking for a clip art of God's hand | Excel Discussion (Misc queries) | |||
Hybrid Mode
