Thursday, 10 May 2012

Singapore 4D lucky number generator

For 4D fans in Singapore, here is a spreadsheet to help to generate lucky numbers!
Gambling is bad, this is just for fun :)

All you have to do is use
=RANDBETWEEN(1,9999) in all the winning numbers cells
and then format the cells to custom -> type = 0000

I have uploaded the excel file and you can try out 'live' using this link:
https://skydrive.live.com/redir?resid=F0F21B96ADB9B690!109

Sample looks like this:

Singapore 4D lucky number generator

:
Good luck!

Wednesday, 9 May 2012

Excel random number generator

Creating a random number generator is easy:)
All you need to know are the functions RAND( ) and RANDBETWEEN ( )
Let me show you an example on how to create a lucky number generator using the concept of random number generator in Excel.

RAND ( ) gives you a number from 0 to 1
RANDBETWEEN ( ) gives you a number between the range you want. In this case from 1 to 9999.


excel random number generator



Monday, 7 May 2012

Excel VBA Macro hang due to endless loop

To address Excel VBA Macro hang due to endless loop, all you have to do is to press CTRL + Break

done!

Insert Euro, Pound, and other symbols in Excel

If you want to insert any special symbol in Excel, all you have to do is to click the insert tab -> symbol -> the symbol you want -> insert

Insert Euro Symbol in Excel


Done!

Other ways include:

Alt+0128 using numeric keypad (the one at the right)
or
Select a cell and type = CHAR(128) in the formula bar


Fancy symbol like € © £ ¥ ® ™ ± ≠ ≤ ≥ ÷ × ∞ µ α √ ? you can just do the same!