I need to format a column to display the time as 0130...without the colon. Is there an easy way to do this?

In excel or word 2007, I'm trying to angle the top row of a table along with the angle of the text. I'm able to angle the text easy enough, but the cell is...

Hi All, I'm able to refer a sheet1 named range for a datavalidation list box in sheet2. Data-Validation-Allow=List,Source="=products" (products is named...

I believe this question has been asked and answered before, but sigh, I did not pay attention at the time, and it is hard to find the threads now. Using an...

I have created a pivot table (say Pivot-1) using source data from a sheet that contains around 18000 records/ rows of data. I created several other pivot...

Can anyone help me with this problem? When I use "Fill-Down" (ctrl-D) and "Fill-Right" (crtl-R) to fill formulas into cells, I am getting the correct...

I have values on Sheet 1 that will trigger a value on Sheet 2. When I go to Sheet 2 I want all fo the data automatically filtered (no manual interaction)...

I understand why I am getting this message I just don't know how to hide that result on my spreadsheet. The problem is I have a column of vlookup resulte that...

In an Excel sheet, I have a column that looks like the one below. *** Insert 18-00-00 2X4 No.2...

We use Communicator 2007 and Outlook 2003. I would like to log all conversations automatically, but the two check boxes to enable logging to Outlook are...

I have a table with the headings Type, Date, Number of Items, and it is sorted by Type and then by Date. I have made subtotals of the Number of Items for...

I'm working with more than 96,000 rows of data, and I know that Excel2007 will support that, but I need to turn off Compatibility mode? How do I do this?

Is it possible to have TO many formulas in a spreadsheet? Have a rather large worksheet for an 18 month rolling forecast and the sheet shows "calculate" in...

I need a worksheet change macro that can do the following. For cells B16,17, 18, 19, 20, 24 - 28, and 31 -34, i would like to have those cells checked for...

Hello! Im curious to find out if it's possible to insert the page numbers & sheet names of other sheets into a table which summarizes all the sheets. for...

I have a Pivot table with different word strings on the Row section and both sum of Data and Count of word strings in the Data section and I can't figure out...

I am trying to create a time sheet with the following columns: Time In, Time Out, Lunch and Hours Worked. The Time In and Time Out columns are formatted...

In order to calculate time does it need to be milatary time or is there a formula to calculate time as : 11:00 In 1:45...

I have a table I am using as a receipt book, I am using for summer camp payment. I enter the receipts as I get them and each receipt is about 8 rows and 15...

I have two columns that are related, name and score, that run from A2:B335. I would like to keep these columns together and have them distributed evenly...