Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
What happens that sometimes when I take a number from Access and paste to
Excel it wants to delimit the number by the comma. I closed Excel and Access and reopened them and tried again and then it was ok. But then later not. What is happening that Excel wants to start asking on the paste special "Text" or "Uniform Code". I can't remember if those are the exact words but when that box comes up and it means things are actiing up on me. Thank you for your help. Steven |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel likes to help. If you've ever imported a comma delimited text file or run
Data|Text to columns (delimited by a comma), then excel will figure you want to do this when you try to paste the next time. But excel's memory is forgotten if you close and reopen excel. Another way is to do a dummy Data|text to columns. put asdf in an empty cell select that cell data|text to columns delimited but uncheck all the options and finish up And then clean up that dummy cell ==== And from what I've read with access and excel, it's better to open excel before doing the copying in Access. (From a non-user of access.) Steven wrote: What happens that sometimes when I take a number from Access and paste to Excel it wants to delimit the number by the comma. I closed Excel and Access and reopened them and tried again and then it was ok. But then later not. What is happening that Excel wants to start asking on the paste special "Text" or "Uniform Code". I can't remember if those are the exact words but when that box comes up and it means things are actiing up on me. Thank you for your help. Steven -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
That's it. Thank you.
"Dave Peterson" wrote: Excel likes to help. If you've ever imported a comma delimited text file or run Data|Text to columns (delimited by a comma), then excel will figure you want to do this when you try to paste the next time. But excel's memory is forgotten if you close and reopen excel. Another way is to do a dummy Data|text to columns. put asdf in an empty cell select that cell data|text to columns delimited but uncheck all the options and finish up And then clean up that dummy cell ==== And from what I've read with access and excel, it's better to open excel before doing the copying in Access. (From a non-user of access.) Steven wrote: What happens that sometimes when I take a number from Access and paste to Excel it wants to delimit the number by the comma. I closed Excel and Access and reopened them and tried again and then it was ok. But then later not. What is happening that Excel wants to start asking on the paste special "Text" or "Uniform Code". I can't remember if those are the exact words but when that box comes up and it means things are actiing up on me. Thank you for your help. Steven -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste Data into Contiguous (Visible) Cells | New Users to Excel | |||
copy & paste formula between spreadsheets - not working | Excel Worksheet Functions | |||
why does ctrl+v paste an image of the screen? | Excel Discussion (Misc queries) | |||
HOw can I paste data into a column with autofilter? | Excel Discussion (Misc queries) | |||
Can't Copy and Paste foumulas? | Excel Discussion (Misc queries) |