View Single Post
 
Old 07-05-2016, 02:16 PM
Lebber Lebber is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
 
Join Date: Jan 2013
Posts: 44
Lebber is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
There is nothing to turn off. Pasting dates results in then taking whatever the default date format is for your system.
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.

Quote:
If you want to use another format, either paste them as values into pre-formatted cells (otherwise you'll just get serial #s)
They will still be transformed. Not a solution.

Quote:
or paste then re-format.
Inefficient and obviously not a solution either.