When I merge an Excel file with various fields/formats, the currency formats the Word file displays 70 instead of $70.00. What do I need to do and in which...

Hi, I have a table that lists the invoice dates. On a monthly basis, I need to write a report of how many invoices were issue, let's say, in January. I...

Good Morning, I use Excel to publish a variety of websites. Normally I use a white background. If I hilite all the cells and use a different color as the...

I am using text to column. Have name-name2 They are separated by a "dash". Want them in two separate columns. What do I put in the destination cell?

hi, is that possible to format the numbers w/o % sign, i.e, the number .4 would appear as 40 and not as 40%? Thanks -- ______ Regards,

Help! My PC came pre-loaded with Excel 2007; however, I see that "Analysis ToolPak" is inactive in the listed Options. I don't have the CDs for MicroSoft...

Hi. I have a spread sheet that I have created several hyperlinks to Word files. From time to time, and for no apparent reason, all of the hyperlinks become...

Running Office 2007. How can I get (or format) dates from the 1700s through 2010 to sort? It sorts dates ascendingly from the 1900 and 2000s just fine but...

I want to reference a cell no matter what happens to it. Simple example: From A1 down: A1=B1 A2=B2 A3=B3 From B1 down:

Ultimately, I want to do a text to columns method but 1st I need to make the data work properly. I have close to 9000 items of vary degrees of numbers and...

At home I have Excel 2007 student version. My boss has Excel 2007 commercial version. Can I work at home and transfer files to my boss's computer? My...

Everytime I open Excel 2007, a windows installer opens and then progresses through a series of windows that tells me to wait while the installer configures...

I want to design a practice test for my students, who need to memorize -- verbatim -- a list of 37 characteristics. I would like to use an Excel 2007...

Why does the format of my pivot chart change, e.g., colors, order, etc. when I "refresh" my pivot data. I have been hitting "save" on the pivot "chart" after...

I am a teacher and I use Excel to quickly, easily create wordsearch puzzles for class and church. When I copy the cells to a graphic program it throws off...

I want to copy data from one work sheet (A) to another (B); instead of using a normal relative cell reference (i.e., copy A1 to A1, A2 to A2, etc), I want...

I have a ss with formula in locked columns and the whole thing protected to stop the formula being altered. When the user comes to the last row in which...

I have many hyperlinks to open files from an Excel workbook. All of these work except for .rm, which has suddenly stopped working. These files open ok from...