You can format the data in your cells a few different ways for currency, dates, percentage, text, and numbers. If you’re working with formulas where you want to format those results, you can use a handful of Google Sheets functions. These functions work with other functions and formulas, but they also work on their own. So whichever way you decide to use them, we’ll show you the syntax and arguments you need....

For example, if you are very comfortable working on Photoshop, getting started with Gimp will take some time. In such cases installing a windows application on Linux is the only option you are left with to complete your task quickly. Today we are going to see how to get these Windows applications running on Linux using the well known Crossover Linux software. It’s not free, but you can download a demo and try it out....

Ever wished you didn’t have to type in your password every time Windows starts up, but you don’t want to lose the additional security that comes with having a password? If that’s the case then today’s your lucky day. Lets take a look. Note: We’re showing Windows 8 in this example, but this should work in Windows 10, Windows 7, or Windows Vista as well. Setting Windows to Logon Automatically Press the Windows + R keyboard combination to bring up a run box, when it appears type netplwiz and hit enter....

Being prepared for your phone to be stolen is the key. There’s not much you can do after the device is gone. Taking some time to be ready for an unfortunate situation can make it hurt a lot less. We’ll give you some tips. RELATED: How to Find Your Lost Android Phone, Even if You Never Set Up a Tracking App Set Up a Screen Lock First and foremost, you need to have some form of screen lock set up on your phone....

It’s easy to see which of your apps are using the most storage space right from the Google Play Store. To get started, open the Play Store and tap your profile icon in the search bar. Next, select “Manage Apps & Device” from the menu. Switch over to the “Manage” tab and you’ll see all the installed apps and games on your Android device. By default, the apps will be ordered by recent updates....

For this to work, you will need to make sure that you have the vmware tools installed and running. You can check to see if the vmware shared folders module is running by running this command: If you get nothing then the mdoule is not loaded. You will need to load it with this command: If that gives you another error, then you don’t have the vmware tools installed, and you will want to make sure to install them before proceeding....

If you’re sick of receiving certain promotional or newsletter emails in your Gmail account, use Gmail’s “Unsubscribe” option to opt-out of all those emails. Here’s how to do that on your desktop and mobile phone. Note that once you unsubscribe from an email, it will be a few days until you stop receiving new emails. Unsubscribe From Emails on Gmail’s Desktop Version If you are on a Windows, Mac, Linux, or Chromebook computer, use Gmail on the web to unsubscribe from your emails....

The Basic Timelapse The basic idea of a timelapse is easy to understand. It’s a video with an incredibly low frame rate. When you watch a movie, you’re seeing 24 photographs every second. Representing one 24th of that second for every individual frame. This isn’t as fast as reality of course, but it’s fast enough that our brains perceive smooth motion. As you add more frames for every second, the motion becomes ever more smooth, until you approach an image that’s eerily like looking through a window....

Double Click My Computer and right click on your root drive. Which is usually Local Disk (C:) now choose Properties. Under the General Tab uncheck the box next to “Allow Indexing Service to index this disk for fast file searching”. Click Apply. In the resulting window make sure to check “Apply changes to C: , subfolders and files. Click OK. While the new attributes are applying you will see the progress dialog box....

StumbleUpon: http://mysticgeekhtg.stumbleupon.com/ Lifehacker: http://lifehacker.com/commenter/mysticgeek.htg MySpace: http://www.myspace.com/mysticgeeksrealm Twitter: http://twitter.com/mysticgeek I know this is a rather small list, I will add more as I have time. If you would like to see me create a profile on a particular network which you are a part of just leave a comment!

In Windows XP, you could right-click any network connection and select “Open Network Connections”, but in Windows Vista, the only option you have is to open the Network and Sharing Center via the same right-click menu. To immediately open the connection list, you can just type ncpa.cpl into the Start menu search box: And up pops the network connection list just like I’m used to: You can also create a shortcut somewhere to the full file path if you want even easier access....

Why You Should (or Shouldn’t) Modify the Undo Limit There are good arguments on why you both should or shouldn’t modify the undo limit in Microsoft Office. Both of these arguments have pros and cons, so consider carefully which works best for you before making a decision. By default, you can undo up to 100 of your previous actions in Word, Excel, or PowerPoint. In most cases, this is a good place to be....

Scanning for Malware The nice thing about Ad-Aware 2009 is that as soon as you finish installing it, it will automatically check for and download updates. Once the updating process has finished, you will be asked to restart your computer. After restarting, the following window will display and you can start your scan for malware by clicking on the “Radar Symbol”. After you have clicked on the “Radar Symbol”, this is the window that you will see....

The Samsung 990 Pro (this isn’t an Evo-branded drive) is specifically built for 3D rendering, 4K video editing, data analysis, “graphically demanding games,” and other tasks that require constant read and write disk access at high speeds. Samsung didn’t specifically mention if it’s compatible with the PlayStation 5 (which can accept third-party SSDs if they are fast enough), but the older Samsung 980 Pro worked with the PS5, so it’s a safe bet....

With a little tweak that originally came from the resource kit, we can add a menu that will let us save and restore the desktop icon positions by right-clicking on the Computer item on the start menu (or desktop icon). Install Download and extract the zip file, and then copy Layout.dll into your C:\Windows\System32\ directory, assuming you’ve installed Vista on your C: drive. Next, you’ll need to double-click on the Layout....

Scribus is an Open Source program that brings award-winning professional page layout to Linux/UNIX, Mac OS X, OS/2 Warp 4/e ComStation and Windows desktops with a combination of “press-ready” output and new approaches to page layout. Underneath the modern and user friendly interface, Scribus supports professional publishing features, such as CMYK color, separations, Spot Colors, ICC color management and versatile PDF creation. Installation Here we take a look at installing Scribus on our Ubuntu system....

For every application that is installed on your server, you should make sure that you have the correct scripts in /etc/rc(x).d to gracefully shut down the service. ShutdownYou have more than one command option that you can use. The best command is this, executed as root: This will immediately shut the system down. You can also use the older command that still works: You can even use: RebootIf you are trying to reboot the system as opposed to turning it off, you could use:...

The Sony LinkBuds are part of a subgenre of headphones with what’s called an “open” design. This technique is an alternative to the type with rubber tips that create a seal in your ear. Those are designed to block out ambient noise, while “open” earbuds let it in. While most “open” earbuds simply don’t create a seal, Sony took the idea very literally. The LinkBuds have an actual opening directly in the middle of the speakers....

Write caching isn’t enabled by default for external drives because removable devices could lose data if you unplug them too quickly, so take care when using this setting. To change this setting, just type Device Manager into the start menu search box, and hit enter. Browse down to the external hard drive that you wish to enable write caching on, and double click it to open up the properties screen....

Note: This article is out of date. Please read our updated article, Sync the Clock with Internet Time Servers in Ubuntu 10.04 To enable this feature, first we’ll right click the clock and choose Adjust Date & Time: You should see this screen, where you can select the checkbox to synchronize the time: Most likely, NTP support has not been installed on your computer, unless you had installed it before....