General

Excel to PDG Format Error
Hi, I am used to using Excel 2007 to convert my workbooks into PDF's. However, recently, all of a sudden, everytime I PDF a workbook my Formating and graphs are all wrong. I have noticed that this only happens when I do multiple sheets, but the problem with doing individual ones is that I can't combine them ... 4 May 2010 13:29

Format Text to Number
I am using excel 2007 and I am trying to create a macro that will convert account numbers which are stored as text to a number format. I want to get a record count on how many account numbers there are. Any ideas? Thanks, -- Bruce ... 4 May 2010 12:21

Format Text to number
I am using excel 2007 and I am creating a macro that will count the number of account numbers in a column. The problem is that the account numbers are stored as text not number. This prevents the count() function from working. Is there a way to get this accomplished. Thanks! -- Bruce ... 4 May 2010 13:29

How do you turn off the clip board option?
Every time I use the cut and paste method for moving items, the clip board opens on the right side. Is there a way for turning this option off? ... 4 May 2010 13:28

Spreedsheet for Transfer of Undertakings Employee Information
I am looking for a spreedsheet for TUPE for all employee's information Can anyone help? ... 4 May 2010 12:21

IF OR Statements
Anybody know how to write a formula for a statement involving "if" and "or" statements such as: if (cell x=? and (cell y=? or cell z=?)) then cell Q=? or blank ... 4 May 2010 12:21

Sort Question
Can you sort a cell by color? ... 4 May 2010 13:29

Embedding Excel Data into Word
Hi, Have trawled through the forum and couldn't find the answer so hopefully one of you clever people can help me :-) I have a user who is embedding a simple table from an Excel document into Word (he does this by copying the data from Excel, selecting Paste Special in Word and then choosing Microsoft Offi... 4 May 2010 12:21

Chart sizing
Hello, I have 2 questions: - when I resize a chart, the x-axis disappears, but there is room within the object border - how do i stop this from happening? - is there a way to resize and tile charts to a standard size that I can determine? Hopefully I won't have to keep using lotus. Thanks for your assistan... 4 May 2010 12:21

Scroll up to ?
Is there a way so that the scroll bar show me up to the 100th row? ... 4 May 2010 12:21