General

2003 documents converted to 2007, lines drawn in are misaligned
I have 100s of documents converted over to 2007 and anywhere there were lines drawn in from the "shapes" menu - they are not lining up properly on the page when printed out. ... 5 Apr 2010 11:38

to find the repetitve text from a column.
JANUARY -44 JUNE - 20 FEBRUARY - 37 DECEMBER - 56 JUNE - 96 JUNE - 56 SEPTEMBER - 46 OCTOBER - 15 NOVEMBER - 87 DECEMBER - 66 DECEMBER - 12 dear All, i have this data in 2 columns and I want to show automatically in one cell as 'december' and in the next cell the total of december (134). please help m... 5 Apr 2010 10:30

IF need to add a third value
my formula is =IF(B5>=C5,"G","Y") I really need to add a third value of "R" if the logical test exceeds a value beyond what is in the current formula. Thanks in advance for your assistance! ... 5 Apr 2010 10:30

convert text "20100315" to date format
Hi, I have some data exported from a system, the date is a text displayed as "20100315" which should read yyyymmdd. I need to convert this text to another date format showing mm/dd/yyyy in text for importing into another system. As the text format yyyymmdd does not contain any "/" or "-" so using text to co... 5 Apr 2010 21:44

Excel 2010
Hi all, I downloaded office 2010 from internet. But when I tried to create Excel fil by right clicking > New on desktop there is no Excel icon available. Though Excel is running perfectly when I choose Microsoft Office Excel from Office Group. This why i am asking that I have to export some data in excel and... 6 Apr 2010 02:06

restrict view of certain cells in excel
I am trying to restrict access to some users in excel. I am trying to make it so those that do not have the password can view the sheet "read only" but cannot view certain cells. Those that do have the password can view all cells. ... 5 Apr 2010 08:18

Calculate How the Number of Specific word.
Valid Expired Valid Valid Expired Is there any way of how can I calculate the number of a word in a column?. For Example I want to Calculate How many [Valid] in Column A. ... 5 Apr 2010 03:59

percentage in excel
hi i'm new to excel. i need to know have to do a formula for percentage. example: total sales £22.50 i need to subtract 3.9% from total sales any help would be great ... 5 Apr 2010 06:07

Paste Value Error
I have a simple formula which evaluates to 4.3. If I copy the formula and paste as value, the value I get is "4.29999999999995". For example: Finding the difference of 999(A1) and 994.7(B1) with "=B1-A1" the value returned is 4.3. Put if you copy the formula and paste special as value only you get the 4.2999 ... 4 Apr 2010 21:31

Workbook_Open code help
HI I'm trying to put code in the open workbook area so that sheet1 and sheet2 both open with the cursor on A200. I'm getting errors with this code : Sheets("Sheet1").Range("A200").Select Sheets("Sheet2").Range("A200").Select Can anybody advise how to do this? Thanks ... 4 Apr 2010 21:31