Combining Cells in Excel

In Excel we can do much, such as i am gonna show how to combining cells in excel.

combine multiple cell ( minimum with 2 cells ) with &
Example :
cell a1 : Together
cell b1 : Forever
with this formula we can get TogetherForever.
How do you do it ? Heres how, just use this formula =a1 & b1

And You can use space to get Together Forever with this formula = a1 & " " & b1
Interesting isn't it?

Combine text with number too.
example :
cell a1 : 4
cell b1 : Ever
How : ="Together " & a1 & b1 ==> you'll get Together 4ever

combine text with date
="today is : " & today() ; u'll get today is : 40749
to fix this :
="today is : " & text(today();"dddd") ; u'll get today is : monday


For Others :
Format a date
="Payment is due " & TEXT(today(),"dd mmmm yyyy")
result : 25 July 2011

Format number as currency
="Amount due: " & TEXT(2500000;"Rp #.##,##00")& " Idr"
result : Amount due Rp 2.500.000,00 Idr

Format a number as a percentage:
="Your Popularity is " & TEXT(0.8,"0%")
result : Your Popularity is 80%

Format a number as a fraction:
="Hours worked: " &TEXT(5.25,"# ?/?")
result : Hours worked: 5 1/4

thx for reading this blog.

Linux User : What is i386, i586, i686

I just found out that linux has so many version Hardware than windows.
Windows only have 2 kind version of Hardware, which is x86 (32 bit) or x64 (64 bit).
Linux has 3 version of hardware, and that are i386, i586, and i686.
the differences are :

kernel i686 -> Pentium Pro/Celeron/Pentium II/Pentium III/Pentium IV
kernel i586 -> Pentium-Classic
kernel i386 -> 386/486

linux user can check what kind version of your hardware by type this command :
#cat /proc/cpuinfo ( check your model name )


the sources that i quote from : http://www.linuxquestions.org/questions/linux-hardware-18/what-is-the-meaning-of-i386-i686-and-where-i-can-find-this-information-327233/

HOW TO CPANEL 11 WITH GOOGLE APPS - MAIL

Here's a some tips how to set cpanel 11 with mail of google apps.

1. Create an account for your google apps - choose standard (http://www.google.com/apps/intl/en/group/index.html)
2. Choose your domain ( buy from google or add from existing domain )
3. Get your domain verified with G-Apps ( in my case : download google88c16fb7xxxxxxx.html and copying to my root www domain )
   
4. Now your done registered with g-apps. Just don't forget to add your user email account.
5. Open your CPANEL and Log In
   
6. Go to MX ENTRY
7. add this :
1 aspmx.l.google.com 74.125.45.27
5 alt1.aspmx.l.google.com 74.125.93.27
5 alt2.aspmx.l.google.com 74.125.113.27
10 aspmx2.googlemail.com 74.125.43.27
10 aspmx3.googlemail.com 72.14.213.27
10 aspmx4.googlemail.com 209.85.229.27
10 aspmx5.googlemail.com 74.125.157.27

8. and you ready.

If you want to change your url http://mail.google.com/a/mydomain.com to MAILS.MYDOMAIN.COM

1. Then go to CPANEL
   
2. open SIMPLE DNS ZONE EDITOR
3. ADD A CNAME RECORD
4. name mail
   
name : mail.mydomain.com
CNAME : ghs.google.com

5. and save

Now you can try it on

Best of luck from to you all

How to Check your Power Suppy Unit live of dead

Here's the tips how to check your the PSU lived or dead.

First, get the a trigonal clips and bend it in to the U shape.

Second, Plugin your PSU

Third, connecting trigonal clips with cable pin (theres 20 pin) of the PSU ( the Green and the Black ).

If the fan is on the the PSU is lived, if not then its dead ( U can throw it away or sell it )

Shorcut for Windows 2000 or XP Management Console

Here's the list of shortcut for Windows Management Console :

Computer Management : compmgmt.msc

Disk Management : diskmgmt.msc

Device Manager : devmgmt.msc

Disk Defragment : dfrg.msc

Event Viewer : Eventvwr.msc

Shared Folder : fsmgmt.msc

Group Policies : gpedit.msc

Local User and Groups : lurmgr.msc

Performance Monitor : perfmon.msc

Resultant set of Policies : rsop.msc

Local Sevuruty Settings : secpol.msc

services of windows : services.msc

Component Services : comexp.msc

And for bonuses :

If it happens u found this messages "Ntldr is missing" then go with this tricks :

Go Booting with original cd's and re-copy ntldr files from the cd's or u can copy from other computer with the same os.

How to Insert Excel in Word

There's lots of ways to insert excel in word.

But i'm gonna show u'all how to insert a long excel to one page word.
First open your excel and use page break preview to see your work in 1 page.
Second copy you excel and open your word and go to Edit , Paste Special and Picture (Enhanced Metafile).
Third well your excel become an image and you can move or drag or even resized.

Well believe it or not....

Mencari uang online - Make money Online

IF YOU ARE LOOKING FOR PAY PER CLICK SITE THAT REALLY PAYS.

GO HERE :

http://pay-per-click-ptc-ppc.blogspot.com/