General

Proper syntex to use
I have a column of dates of wells that are drilling on given dates throughout the year. There are also some dates that are in the same column that are rig mob dates that I don't want to count those. Example: Date Drilled 1/1/2010 2/12/2010 3/10/2010 4/1/2010 Rig Mob 5/10/2010 6/12/2011 7/10/2012 8/5/... 10 Feb 2010 15:42

Stacked Column Charts help!
I have a stacked column chart for some accounts I have and I'm trying to add a YTD total at the end. I have 7 different accounts that are stacked going from jan to dec, and then the last column on the right is YTD. I added the YTD by adding a column in my data with the sums of the monthly data, but the YTD co... 10 Feb 2010 14:34

Adding up hours and minutes
I have been reading the answers to hour/minute type questions but can't seem to find the answer I need... I am trying to calculate total hours worked in during a night shift like this: A1 = 02/05/10 8:30 PM B1 = 2/06/10 7:00 AM C1 = B1-A1 = 10.30 I would like the 10.30 to appear as 10.5 instead. Could... 10 Feb 2010 15:42

Text to Columns
500+ sentences, I need to seperate (text to columns) after the first "-" only. There are subsequent "-" but I only want it seperated at the first. And when I seperate it in the second column I do not want a space preceeding the text. Can you give advice on this, any help would be much appreciated! Thanks ... 10 Feb 2010 14:34

AUTO-POPULATE WORKBOOK WHEN OTHER WORKBOOKS ARE CHANGED
I have a situation where 4 people have individual workbooks that they track their daily work. Each of the 4 workbooks have tabs for each month of the year, which they then track items such as Date Received, Customer Name, Account #, Order #, Due Date, Ordered By, etc. I am trying to find a way to summarize ea... 10 Feb 2010 12:17

Making the text in a cell with a money format centered
Is this possible? I've tried but the text in the cell always sticks to the right... ... 10 Feb 2010 19:07

Sum if a cell is not a certain data
Hi, I have a set off data like this...... Jonno 3 Alex 5 Jonno 5 Simon 5 Simon 5 Alex 3 and i have a formula to calculate the total sum of jonno's (i.e 8) but i would like it to calculate if its not jonno i.e simon and alex (18) am thinking this will be possible but i cannot figu... 12 Feb 2010 05:29

How to turn off accepting the licensing agreement when open excel
Everytime I open Excel or Word I have to accept or decline the licensing agreement. Is there a way to turn this feature off? ... 10 Feb 2010 13:26

Right click and see font details
When I right click on my cells in the worksheet, the font details are now displayed in Excel 2007. Is there any way to disable this? -- Breeze ... 10 Feb 2010 08:53

Filter a list for missing numbers
I have a rather long (2000) list of stamp numbers, and want to filter out and print a list of those ( from 1 to 2000) that are misssing..a "want list". Tried some options but didn't get anywhere. Thank you. Excel 2003 on Vista. ... 10 Feb 2010 08:53