Reputation
12,010
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
3 25 35
Newest
 Enlightened
Impact
~1.8m people reached

Apr
16
reviewed Approve Windows environment variables. How do I change the name that I must type at command prompt to run a path target
Mar
31
awarded  Enlightened
Mar
31
awarded  Nice Answer
Mar
27
answered Detect If New Line Is Started In Excel?
Mar
15
awarded  Nice Answer
Dec
20
reviewed Approve Using Rectangular Marquee Tool in Adobe Photoshop CS6
Dec
9
revised How to protect router access (Router: W/TW Arris DG1670a)?
Added summary sentence.
Dec
9
answered How to protect router access (Router: W/TW Arris DG1670a)?
Dec
7
awarded  Yearling
Nov
27
reviewed Edit Web server not allowing certain HTML tags
Nov
27
revised Web server not allowing certain HTML tags
formatting
Nov
12
comment Finding a way to auto update a formula based on real dates in excel
Voting to close as too broad and not enough detail. That said, if you want Excel to recognise the "date change" you should be using functions like NOW() and/or TODAY() which continually update. You can also enter "frozen" values of the current date or time in cells with keyboard shortcuts Ctrl + ; and Ctrl + :.
Nov
11
comment Formatting numbers in excel so they are in parentheses
@FBert, yes, ="4.44" is a text value, not a numeric value so the custom number format as specified will not be applied. If you want to place parentheses around text values as well then you can supply a full custom format for positives, negatives, zero and text, which would be "("0.0")";"("-0.0")";"("-0.0");"("@")" but I recommend you to use genuine numeric values wherever possible and your overall Excel experience will be much more productive.
Nov
11
comment Formatting numbers in excel so they are in parentheses
@jo99blackops, OP was suggesting to type '(5.6) including the parentheses. It works under all versions of Excel but converts the result to a string of text, no longer a numeric value.
Nov
11
comment Formatting numbers in excel so they are in parentheses
The answer works but is not very useful because the numbers are converted to text and can no longer be used for calculations.
Nov
11
answered Formatting numbers in excel so they are in parentheses
Oct
29
answered How to make a cumulative sum ignore negative numbers in Excel
Oct
19
comment Verify value in cell is present in another range
+1, much easier than my method. I forgot about COUNTIF
Oct
19
answered Verify value in cell is present in another range
Oct
16
comment I want to run a script that will disable my touchpad
Does the script disable the touchpad when you run it manually?