MS Word Mail Merge: Not making cents?

This issue comes up when writing a mail merge letter where you are including dollar amounts from a calculated formula column — such as... “Money Turned In” and “Money Still Due/Owed.” 

In some cases you can just change the cell format to Text, but not if that column/cell has a formula in it and needs 2 decimals to show cents! 

Below is a link to instructions that worked just wonderfully the other morning... BUT (one change to the instructions...) you will need to use “0.00x” for 2 places after the decimal (such as for cents), and “0.0x” only goes 1 place after decimal.

http://wordprocessing.about.com/od/usingmailmerge/qt/NPFSwitch.htm

Excel- Selecting several cells rather than one?

When you click/select ONE cell in Excel, do more than one get selected?

Apparently, it’s the scroll wheel on your mouse... (more info here)
http://www.computing.net/answers/office/excel-click-1-cell-selects-multiple-update/8691.html

Try this to fix it:

1. Click on scroll wheel (and let go), you’ll get a compass-like 4-arrow symbol. 
2. Without clicking, move the mouse up, down, left, right — your screen will scroll in those directions. 
3. Now press the wheel again to go back to normal mouse mode. 
4. Now left-click a single cell — it should just select ONE cell. If not, try again! (or leave a comment below and I’ll do a Jing video to show you what to look for)

How To: Combine 2 Columns into 1 in Excel ("Concatenate")

This question comes up sometimes... “How do I combine the first and last name columns into one column?” (by the way, this is officially called concatenation, which essentially means “linking things together”)

I’m sure some of you already know how to do this, but I didn’t. So, I decided that rather than ask our Tech Director how to do it (which I was going to do since I know she knows how to do it and could tell me/show me really fast), I decided to “Google it”! In Google search, I typed “how to combine two columns in excel” -- (here's the search results page... can't guarantee that the current results match what I got, but...)

Below is what I found... (first link!) It’s a YouTube video (which we, staff, all have access to now) and about 3 minutes long... A lot less time than it would take to retype all these names!!! The guy is a little goofy, but it’s a great demo of this plus a few other little tips (a couple I didn’t know!!!): http://www.youtube.com/watch?v=fe91iB_4bR8

Perhaps some other of his other videos might be helpful as well, I know I will be checking back with him...

Excel Calendars

Below is a link to calendar template files made in Excel that you can download free for personal use (no selling them, please!!!!)  ;-)  Just to mention, these do contain macros, so check with your tech staff BEFORE using, if there are concerns.

http://www.vertex42.com/ExcelTemplates/yearly-calendar.html