This however changed the dates to numerical values, so you will need to change the format back to date. I needed to add one day to each date, so I put the number 1 in general format, copied it and then used paste special. Just tired this with dates, seems to work though you need to change the cell format. Subscribe to our Youtube Channel for more tutorials.

“Use Paste Special to insert static or linked data into Excel.” While there are easy ways to find this kind of information in more traditional means - like using a calculator - the Paste Special box can be a tremendous time-saver and can be advantageous to virtually any business. This can show how much all of your products will cost during the sale. Copy 0.80 from an empty cell on your spreadsheet and use the “multiple” paste special operation. For example, say your company is running a promotion that decreases the price of your products by 20 percent.

If you have lots of rows and/or columns of data that you with to update in the same way, the paste special tool is the easiest way to accomplish this. Note: Any discussions should be made in a new thread - they cannot be added to this one.As the video above shows, you can do basic mathematics with this tool without using any complicated formulas.

Parsing Numbers Separated By + Or - Signs.

Rounding Numbers To The Nearest Multiple.

Referencing Row And Column Totals From Outside A Table Reference Table Cells From Outside The Table Testing Or Returning Cell Contents In Tables Referencing Adjacent Cells In A Row Or Column Testing Or Returning Text Strings With Logical Functions In Bookmarks AND And OR: Testing Multiple Logical Numeric Expressions Attached is a document I've created to show how to do various mathematical calculations using Word fields, including some possibilities for string testing & manipulation.

Microsoft word math functions