General

Formatting issue
I have extracted data from a PDF file into Excel using Able to Extract program. In the PDF file, negative numbers are stored with the minus at the end., ie., 12345.00-. I need the numbers to have the minus in the front, i.e., -12345.00. I cannot get Excel to format for me. Any suggestions? ... 2 Feb 2010 17:28

Want to add a dot in between to Names
Hi, I have a huge data of customers names. I want to take out the first letter of each word in the name and add with a dot. Is there any formula? Example:- Tiger Woods as T.W. Sachin Tendulkar R as S.T.R. Adam John Gilly as A.J.G. Pointing Jr. as P.Jr. -- Thanks and all your help will be much appriciate... 2 Feb 2010 17:28

Conditional Formatting
Hi All, I need help on conditional Formatting. I have a column of data with future DATE, such as 2 Jan 09, 4 Des 09, etc I would like to assign automatically different colors to those data that match these condition: If (TODAY's date < Data's date) And more than 30 days, COLOUR is Orange If (TODAY's date ... 2 Feb 2010 17:28

how can i alphabetize footers in excel?
I have 180 pages with name titles and want to put them in alhabetical order. ... 2 Feb 2010 17:28

Converting multiple data codes to numbers
Hi there, I have an extensive data set entered in excel. The data includes several codes with number-letter combinations (e.g., 1a, 1b, 2f, etc). I need to convert these codes to numerical values (e.g., 1a = 1). There are too many to use the search / replace command. Is there a formula I can use to change... 2 Feb 2010 17:28

All colors in Office documents are grayscale, how do I see colors
... 2 Feb 2010 17:28

Rank Question
I need to figure out how to rank by manager ex: Processor Manager Score Rank Albert Scott 80.9 2 Brian Scott 91.5 1 Cathy Scott 79.3 3 Mable Delores 99.9 1 Elaine Delores 95.6 2 Tony D... 2 Feb 2010 17:28

Modify Keyboard Shortcuts? Excel 2007
Hi I'm also interested in this. What would be the code for both increasing and decreasing the number of decimal places? Thanks "DougG" wrote: I didn't before, but I do now. Thanks - that worked perfectly. Pretty weird that there's no simple way to change the shortcut keys though. The Shortc... 2 Feb 2010 17:28

How to avoid '*' being used as wildcard in SUMIF?
A data field for which I wish to do a SUMIF begins with the character "*". e.g I have a Product Code of "*SPEC" where the * is the first character of a 5 character code. When I do a SUMIF the answer includes any row where the Range value ends with the characters "SPEC". I do not want the "*" being used as a ... 2 Feb 2010 17:28

MS Query Joins
I use MS Query in Excel often. I am trying, however, to change the Join and am given 3 options when I double click on the join between two tables. When I do that, the botton 2 options are grayed out (I can't create inner/outer joins). WHy is that and how can I get them "un-grayed" so I can change the join ty... 2 Feb 2010 17:28