P
phil
I use this VBA code:
activesheet.pastespecial format:="text"
to copy in something that I have pasted in from a website using the
clipboard. This has worked forever (and still does on another copy of Excel
that I have installed on a different machine). All of a sudden, a value such
as
$125,341
gets copied into 2 adjacent cells and looks like this
$125 341
Needless to say, the VB code that processes this new data result no longer
works. The same thing happens if I use "paste special" from Excel directly,
rather than using VBA.
This seems like one of those mode switches that you can accidentally set the
wrong way without realizing it.
How do I get Excel to copy the above data into one cell again?
activesheet.pastespecial format:="text"
to copy in something that I have pasted in from a website using the
clipboard. This has worked forever (and still does on another copy of Excel
that I have installed on a different machine). All of a sudden, a value such
as
$125,341
gets copied into 2 adjacent cells and looks like this
$125 341
Needless to say, the VB code that processes this new data result no longer
works. The same thing happens if I use "paste special" from Excel directly,
rather than using VBA.
This seems like one of those mode switches that you can accidentally set the
wrong way without realizing it.
How do I get Excel to copy the above data into one cell again?