General

How do i hide carriage returns?
How do i hide carriage returns? (the "boxes" behind a line of text) ... 28 May 2010 13:46

Final Reminder - Microsoft Responds to the Evolution of Community
Microsoft Office Evolves Community as Part of Office 2010 Launch: As you know, this is a big year for Microsoft as we are launching the latest version of Office. Office 2010 is all about making it easy for you to get and use Office on your terms. Office 2010 lets you work from the office, from home, or at s... 28 May 2010 12:40

Count occurance of months
Hi Folks, I am using the following formula to try to count how many cells contain a date within January but its not working for me =SUMPRODUCT((MONTH('Tracker 2010'!T6:T2643)=1)*('Tracker 2010'!T6:T2643<>" " )) Date format is 13/01/2010 in T6, 16/01/2010 in T7 and so on Any help you could give is appre... 30 May 2010 07:53

conditional formatting for more than 3 conditions
Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please he... 28 May 2010 14:53

Copy within a subtotal
I have a large worksheet where there is already subtotalling. I'm looking to add a subtotal to one column. Because of additional formulas and information that that has been added to the subtotal lines, I cannot use the subtotal function to add one more formula. If I can find a way to copy just the subtotal... 29 May 2010 12:29

Date changes in data
I have a spreadsheet that has a date column which is required. The spreadsheet is then uploaded for a conversion into another software product we use. This date column is only for the year. When we enter the date such as 2010 and format the column as custom, yyyy, it will change the date to 1905. We have tried ... 28 May 2010 12:40

pivot to represent multiple occurances as 1, but link to all ocura
I have a list of data in which I wat to pivot to show only the number of different occurances in column "A"(this example is two-bub & ubu) but i also want it to pull in all occurances of column A when i click on that finding in the pivot table. is that possible? A B 1 bub 1.25 2 bub ... 28 May 2010 17:05

Pivot Table Field Settings
I have a table where one column of my data that I am counting will have Zero or Null Values in some rows. How do I exlcude those rows, so the data shows mee all non Zero items ... 28 May 2010 11:34

stop changing of format
I want Excel to stop changing my set word wrap funtionality from off to on when copying or deleting data in a workbook. I will copy data from one sheet to another only to have Excel reset the WordWrap funtion back to on from off causing the cell with the data to get much larger. If I wanted the feature , I wo... 28 May 2010 10:27

text combined with values
In cell A1 I typed s1.5 in cell A2 I typed s2 how do I add the values to equal s3.5? ... 28 May 2010 10:27