This is a handy way to quickly change things like dates, prices, and times without using formulas.
Let’s take a look.
Here we have some examples of information we want to change.
In the first example, we want to increase prices by 10%.
Obviously, we could just add a new formula that multiplies the existing price times 1.1 in another column.
Then use Paste Special to paste over the original prices.
But how can we do this without all that busy work?
One way is to use Paste Special.
Now, with no formulas at all, we have prices that are 10% higher.
you could use the same approach with dates.
For example, suppose we want to adjust these dates forward by one week?
Well, remember that dates are just serial numbers.
So, one week equals seven days.
To make the adjustment, I can enter 7 in a cell, and then copy.
Then I follow the same process as before, but this time using the Add option.
This works for times as well.
Suppose that we want to make a time-zone adjustment of + seven hours to these times.
One hour equals 1/24.
So, to get the equivalent of seven hours, I can just multiply that by 7.
