Quote:
Originally Posted by macropod
There is nothing to turn off. Pasting dates results in then taking whatever the default date format is for your system.
Quote:
Originally Posted by Lebber
I want to be able to paste somethign like "24-7" as "24-7" and NOT transform it in any way. That's precisely the issue I have.
|
If you want to use another format, either paste them as values into pre-formatted cells (otherwise you'll just get serial #s)
Quote:
Originally Posted by Lebber
They will still be transformed. Not a solution.
|
|
Evidently, you've never heard of preformatting the destination as text... Content like '24-7' pasted from another application will remain '24-7'. Likewise, it seems you've never explored the 'Paste Special 'options, one of which is 'Keep source formatting'...