Is there a Stack Exchange site to ask about PC configurations?
Give each site a parallel site for polling, recommendations and subjective-ish stuff
Format a number with optional decimal places in Excel I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any.  For example.    15 should be formatted as 15, NOT 15.00 14.3453453 should be formatted as 14.35 12.1 should be formatted as 12.1  0 should be formatted as 0   The closest custom format code I've come up with is 0.##. Unfortunately this formats 15.00 as 15. (note the extra decimal point).  To further complicate the issue, the spreadsheet is a result of an export from SQL Server Reporting Services. So no macros are possible. Oh well, it looks like 0.## is my best bet, and they can just live with the extra period. Does anyone know where I can find cheat codes for Goldeneye 007 Wii? I know that the game hasn't even been out for a week, but does anyone know if any cheat codes have been released by Activision yet?  I know that they must exist since there is a cheat codes menu within the game. How can I swap or replace multiple strings in code at the same time? Remove appx package for all users Fresh Windows 10 install. Somehow the MSN Weather app became corrupted. (Unable to launch) I removed the app with the following Powershell command:     Remove-AppxPackage -Package Microsoft.BingWeather_4.7.118.0_x86__8wekyb3d8bbwe   However, when running     Get-Appxpackage –Allusers   the package is still present. When I attempt to reinstall the app via the Windows Store, the download is skipped and the same corrupted package is installed.  I've tried restarting (many times) and using WSReset to no avail.  What can I do? Thank you! How to make sure that Qt5.4.2 is installed properly I installed qt5.4 from  in Ubuntu 14.04, but when I run:   qmake -v   I always get the old version Qt5.2.1, although I think it is installed here Qt version 5.4.2 in /opt/qt54/lib. Can anyone tell me how to make sure that Qt5.4.2 is installed properly?   Thanks Half exact functor which is neither right exact nor left exact In the following sentence, I want to know if I've understand the correct meaning or not:     This version holds that the wave function does not so much describe the state of the physical system as the state of our knowledge of the system.    Can we say that it means the wave function describes the state of our knowledge  of the system more than it describes the state of the physical system  ?  It is worth noting that in the Cambridge Dictionary, we read:  not so much sth as sth ​ If you say that something is not so much one thing as something else, you mean it is more the second thing: They're not so much lovers as friends. I don't feel angry so much as sad. How to draw line through group plots in pgfplots? This issue has been driving me crazy for the past 10-20h. I have a group plot (pgfplots) where I have 2 plots one under another. I'd like to draw a vertical line (e.g. a helpline at x=150e-6) that would go through all of them.  When drawing inside the axis or rather nextgroupplot environment I can use something like this: \draw[thin] (axis cs:150e-6,\pgfkeysvalueof{/pgfplots/ymin}) -- (axis cs:150e-6,\pgfkeysvalueof{/pgfplots/ymax}); but this allows me to draw only on one of the subplots. If I go outside the axis environment I am able to draw on the entire {tikzpicture}, but I can't use the axis reference.  \begin{figure*}[h] \centering \begin{tikzpicture}  \begin{groupplot}[       group style = {group size=1 by 2, x descriptions at=edge bottom, vertical sep=0.2cm},       ytick={0, 1.8},       ymin=0,       ymax=3,       xmin=0,       xmax=550e-6,       change x base=true,       x SI prefix=micro]  \nextgroupplot \addplot table [x index = {0}, y index = {1}, col sep=comma] {plots/plot1reduced.csv};  \nextgroupplot[x unit=s] \addplot table [x index = {0}, y index = {3}, col sep=comma] {plots/plot1reduced.csv};  \draw[thin] (axis cs:150e-6,\pgfkeysvalueof{/pgfplots/ymin}) -- (axis cs:150e-6,\pgfkeysvalueof{/pgfplots/ymax});  \end{groupplot} \end{tikzpicture} \caption{Case 1} \label{fig:case1plot} \end{figure*} \AtEveryBibitem{\clearfield{Title}} in beamer? Expression for a choice which isn't really one Which QGIS installation for Windows comes with r.in.lidar? Number of onto functions finding the index of a max value in R Which locations are traditionally Santa's home - i.e. where can you visit Santa Claus year-round? Obviously around this time of the year, Santa and his minions will be out and about, finding out who is naughty and nice, and delivering presents.  However, the rest of the year he's back at his home.  Where is that generally considered to be visitable?  Yes, in some traditions it's the 'North Pole', but I know at least one other country (Finland) has Rovaniemi as his home. PDF video Embedding Problem Convert Month Number to Month Name Function in SQL I have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible. I remember my professor in college challenging me with this question, which I failed to answer satisfactorily: I know there exists a bijection between the rational numbers and the natural numbers, but can anyone produce an explicit formula for such a bijection? How can I eliminate condensation on my toilet tank? My toilet is getting a great deal of condensation on the tank and dripping onto the floor. What can be done to address condensation on the exterior of a toilet tank? Turn off close Facebook friend notification How to convert standard IP address format string to hex and long? Does anyone know how to get the IP address in decimal or hex from standard IP address format string ("xxx.xxx.xxx.xxx")?  I've tried to use the inet_addr() function but didn't get the right result.  I tested it on "84.52.184.224"  the function returned 3770168404 which is not correct (the correct result is 1412741344).  Thanks!