| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported numbers change to dates
When I pull things off the internet, Paste Special only allows me to paste
HTML, Unicode Text, or Text. The other Paste Special window is never an option. Thanks for the thought. "Bill Martin" wrote: Have you tried to first format the column to text, and then when you do the paste, use "Paste Special" and select "values"? Your normal Paste also replaces the formats as well as the values. Bill |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Imported numbers change to dates
imajinaree wrote:
When I pull things off the internet, Paste Special only allows me to paste HTML, Unicode Text, or Text. The other Paste Special window is never an option. Thanks for the thought. "Bill Martin" wrote: Have you tried to first format the column to text, and then when you do the paste, use "Paste Special" and select "values"? Your normal Paste also replaces the formats as well as the values. Bill ------------ And have you tried to tell it paste as text after first formatting the cells as text? Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i change dates from US to UK format | Excel Discussion (Misc queries) | |||
| Calculate numbers between 2 dates | Excel Discussion (Misc queries) | |||
| macro to change numbers to names | Excel Worksheet Functions | |||
| My formulas can't 'see' numbers imported from Access in Excel, even when the format is the same. | Excel Discussion (Misc queries) | |||
| how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
