Category: Tips

Creating a random number in Excel 0

Creating a random number in Excel

To create a whole random number in Excel, place the following into the equation line : =INT((RAND()*max)+min) Where min and max are the minimum and maximum values. For example… =INT((RAND()*10)+1) This will generate a number between (and including) 1 and 10. This will be recalculated every time the spreadsheet is opened. Alternatively, press F9 to update the number. If you don’t want the numbers to change every time the cell is calculated, you can enter the equation into the formula...

Changing the location of Firefox bookmarks 0

Changing the location of Firefox bookmarks

If you wish Firefox to look elsewhere for the bookmark file Type about:config in the URL bar Right click within the window and add a new string entry The entry name should be browser.bookmarks.file Set its value to the new location (eg F:\bookmarks.html)

Synchronising Files Across Computers 2

Synchronising Files Across Computers

For some time now I’ve used Microsoft’s Live Mesh software to synchronise folders across a number of computers. It’s a little tricky to set up at first but otherwise is relatively easy to use. The idea is that you mark folder that you wish to add to the Mesh. On your other linked computers, it then creates matching folders where the data is shared. These folders aren’t short cuts, so even though you would have set one up initially on...

T-Mobile G2 Touch & MMS Picture Messages 1

T-Mobile G2 Touch & MMS Picture Messages

Well, I got it fixed in the end. After much discussion with T-Mobile on Twitter and then email, they phoned me. And it was fixed in, well, seconds. It turns out that you can’t download MMS message when you’re using Wi-Fi. Now, this maybe a T-Mobile limited thing, but when you received an MMS, you get a simple text inviting you to download the media that’s attached to it (usually a picture). In my case, I’d click on the download...

Recommended Android Apps – Update 0

Recommended Android Apps – Update

Two weeks ago I posted a list of recommended Android apps. Two weeks is a long time, though, and some of those recommendations have changed and I’ve stumbled across some more. So, here’s an update… Changes WikiMobile has been replaced with Quickpedia for viewing Wikipedia – overall, it’s a much better viewing experience. Advanced Task Manager and ASTRO have been replaced by ES Task Manager and ES File Explorer. There was nothing wrong with the original apps, but the two...

7 Apps that don’t yet work on the HTC Hero 0

7 Apps that don’t yet work on the HTC Hero

There are some apps that I’d love on my Hero but, for one reason or another, I can’t currently get. Talk To Me This is a language translator, which uses both text and speech facilities. Sadly, it needs Android 1.6 onwards. HootSuite HootSuite, an online Twitter client, have had an iPhone app for a while. Now they’ve released an Android version, but it only currently works for Android 1.6 onwards. Thankfully they’re working on a 1.5 version… Google Apps There...

Recommended Android Apps 0

Recommended Android Apps

I’ve had my HTC Hero now for over a month, and have already settled on a number of apps, after much installing, trialling and uninstalling. I therefore thought I’d share my results, all neatly categorised. I haven’t linked to any of the apps, as they should all be searchable in the Android Marketplace. Oh, and I haven’t listed games (they’re a lot more of a personal choice, I find). Information The BBC news widget is particularly useful, providing easy access...

Xmarks and star ratings! 0

Xmarks and star ratings!

The latest version of Xmarks for Firefox has added a new feature where, in the status bar at the bottom of the browser window, there are 5 stars, allowing you to easily rate websites that you visit. Unfortunately, they’re a bit of an “estate” hog and can only be turned off along with the Xmarks icon (which is useful for quick synchronisation). However, there is a way to turn off just the rating stars… Enter about:config in the Firefox address...

More Useful Netbook Software 0

More Useful Netbook Software

My original list of Useful Netbook Software was rather popular so I’ve gathered together some more suggestions for getting the most out of your Netbook. I’ve seen many similar lists on other sites but they seems to suffer from at least one of the following… Concentrating on applications which are, well, generally useful and not really Netbook specific. Free antivirus? Hmm. Recommending the same old “popular” choices – irfanview, OpenOffice, etc. Recommendation are mainly around the theory of moving everything...

Albums not being added to Windows Media Player 0

Albums not being added to Windows Media Player

On my home desktop PC, I’m running Windows Media Player 11 under Windows XP. Last night, when attempting to sync some music with my phone, I realised that a couple of recent albums were missing from WMP. However, they were in the My Music folder, along with everything else. Clearing down the library and getting WMP to rebuild it didn’t work. However, after a bit of searching I found that rebuilding the media library is the usual solution. Here’s what...


Visit our Facebook page, like us and follow all the latest updates, plus exclusive content including competitions.