Search results for query: *

I have an excel spreadsheet and am getting data from my SQL database. In MS Query I have a query to get 3 fields from a database but need it to look better. When I try and use the 'format' next to date field, it gives me an error about 'does not recognize format command'. Do I add the...

I can't figure out what the 'priority' field does. It appears in the Project Information box and also in 'task information' box. Anyone ever changed the default of 500 to something else for a particular reason? Thanks,

I have in one cell street address, city, state zip and I need only the street address in a cell by itself. I have over 40,000 rows of data. Any ideas? Thanks!!

I have 225 333-3333 in a cell and I need only numbers. What is the easiest way to remove the space and hyphen? Thanks!!

I have 500 rows of data with that I'm using 'paste special' to copy values only to new cells. I've created a macro using a toolbar button so that I don't have to use paste special command so many times. Is there an easier way to do this so that I'm not using the macro button 500 times? Thanks!

I have an address in many cells in a list and need to have the last 5 digits (which is the zip code) extracted into a cell by itself. I tried extracting numbers from alphanumeric strings but that also pulls the numbers in the street address. Any ideas? Thanks!!

I'm trying to fix a problem on one machine where there is an error message "powerpoint can't find the link" every time the slide show is viewed advancing from one slide to another. Even if there is not a link on the slide, the error appears. It happens under another login ID also. Any ideas?

I have a list and I need to extract data from one column in four different categories. For example, 0 - 90, 91 - 180, 181 - 300. I need to then get a % of how much data is in each category. What is the easiest way to get this data from a large list?

I have a large list of data (some cells contain numbers and some contain text) and I cannot easily remove the single quote the import put in front of all text. Any suggestions?

I have a large list (over 15,000 rows) and need one column sorted in 4 categories (0-90, 91-180, 181-270, 271-360) I also then need to know the % of data associated with each category. For example, 40% is in 0-90 range, 20% is in 91-180... Any ideas? I have tried advanced filter and subtotals...

I have three avi movie clips in a slide and when playing them, they become enlarged and only the top half appears. When the files are inserted into the slide, they look fine. Does anyone know what I can adjust/edit so that when playing the movie it is not enlarged? In Media Player they play...

Hi, In a particular file, I never want to see the error "Type mismatch" with End, Debug and Help. What statment(s) can I easily add so that a generic more user friendly error comes up instead of this confusing one?

Anyone know why the error "some view settings could not be applied" appears when showing a custom view that has filters turned on? They were working but keep stop working for no reason. The drop down arrows appear but there is no filter applied. I have many custom views in the file that contain...

Hi, I need to count the number of cells in two ranges that meet certain criteria. This is what I have so far: =COUNTIF(I3:I18,&quot;D&quot;) It tells me how many cells in the range are equal to &quot;D&quot;. I also need to know how many cells are equal to &quot;D&quot; and also <500 in another...

I'm using IF and OR in the same formula to compare 3 cells and if any of the three cells are greater than a certain amount, I want to see a &quot;Y&quot;. For some reason, if there is &quot;N/A&quot; in a cell instead of a number, it returns a &quot;Y&quot;. How can I add to the formula to treat...

Anyone know of an easy way to get lots of data into an XY scatter chart? When I select additional cells to add to the source data, the chart reads for some reason at the Y axis on row 2 every time.

Is there any way to see a hyperlink in a pivot table? When adding one to a table, the link is lost for some reason. Thanks!

When using a mail merge to an email, is there any way to customize options on the emails generated? I wanted to flag the messages before they were sent.

Hi, I have a table of contents but am having trouble keeping my tab settings when I update the TOC. I am using captions and then inserting them at the right margin. I've used a dot leader for the tab. Every time I update the field, which is the TOC, the tab settings are lost. Any suggestions on...

I need to print a list of all of the recipients I have in a mail merge. I have the data source with the *mdb extension but can't figure out how to open it to display all names to print. Any ideas?