From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Alter numeric data without formulas

Alter numeric data without formulas - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Alter numeric data without formulas

- [Instructor] There are times 2 when you work with numeric data 3 that you want to make changes to the data 4 but not necessarily use formulas. 5 And you can do that with a feature called Paste special. 6 You might be familiar with that feature 7 for doing other kinds of things with numbers, 8 but a special use of it involves incrementing, decrementing, 9 even dividing and multiplying numbers 10 by a certain amount without formulas. 11 I've got some sample data on this worksheet, 12 and as I click column B for hire date here, 13 I'm looking at the bottom of the screen in the status bar 14 and I see that the highest entry there is April 4th, 2014. 15 Now, let's imagine it's mid 2016. 16 I want my list to appear more up to date. 17 Many of the entries we're seeing already are pretty far 18 in the past, but that's okay because these are higher dates. 19 But I want some of the entries in there 20 to be more recent than the latest…

Contents