General

Time Stamp
I have a dynamic stock quote in cell "B2" ... in cell "C2" I want to record the exact time that the stock price FIRST reachs a certain price. How do I have this cell record this exact time only the first time the stock is at this price and not change it later? -- Ken ... 5 May 2010 09:20

Microsoft Responds to the Evolution of Online Communities
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the rapidly-growing forum platform. This decision is in response to worldwide market trends and evolving customer needs. Microsoft continues to invest in forums t... 4 May 2010 23:32

Microsoft Responds to the Evolution of Online Communities
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the rapidly-growing forum platform. This decision is in response to worldwide market trends and evolving customer needs. Microsoft continues to invest in forums t... 12 May 2010 21:27

INSERT 3 ROWS WHEN DATA OF COLUM CHANGED
Good mornig, pls help me, i want insert 3 rows when the data changed Colum A Row 1 920 Row 2 920 Row 3 920 Row 4 728 Row 5 661 I want insertation automatique 3 rows atfter Rows3 and after rows4. Thans so much. ---------------- This post is a suggestio... 5 May 2010 03:53

How do you limit the total allowed for a group of cells?
I am trying to limit the number of hours that my employees can log. How do I prevent the total of 3 cells from exceeding 80 hours. I tried to limit it through the validation menu, but I have been unable to figure it out. (By the way, they can log in decimals, not just whole numbers). ... 4 May 2010 23:32

Calculate Selected Cells Only?
I have a heavy excel workbook with lots of formulas, every time I did something it was calculating literally for 20mins, so I changed it to Manual Calculate. Now lets say I add a column and do calculate now it calculates the whole sheet/workbook for a very long time. Can I tell it to only calculate the new cell... 4 May 2010 23:32

Conditional formatting dates
I have a range of dates that I want to conditionally format. Eg, todays date is the 5 May 2010. I want to highlight all of the dates in the range D14 to D120 that todays date passes on a daily basis. For eg, as we click over automatically to the 6 May 2010, any fixed dates in the range for the 5 May 2010 turn ... 4 May 2010 23:32

copying editing cells
I have a colum with full names ie John but I only want the first initital - is there anyway to cut and paste or whatever so I only get the first letter from each name ?? So John becomes J and so on thanks -- lbps ... 4 May 2010 23:32

VBA Copy values only onto new workbook
Hi, I've been successfully using Ron de Bruins Mail An Active sheet macro. I however now need to modify the macro so it either: 1. copys Macro Functions onto the new workbook or 2. it pastes Values and Formats Only onto the new workbook opposed to "Set Destwb = ActiveWorkbook". The reason being, I have ma... 4 May 2010 22:25

Setting length of data in Excel
Is there a way to format imported data to always have 5 digits or characters... no matter where the decimal point appears. Example: 12.345 1.2345 123.45 1234.5 Thanks ... 4 May 2010 21:19