If you use a number format like0, Excel simply writes the number with no decimal point or decimal digits. To truncate the last three digits of a number in the thousands, append a comma to the number format, like this:0,. Two commas drop off two sets of three digits, etc. To add a character after the number, K for thousands, append it in quotes:0,"K". Here are a few sample formats for a number in the thousands: Number Format How 12,345.678 is displayed 0 12345 #,##0 12,345 0.00 12345.68 0, 12 0.00, 12.35 0,"K" 12K 0.00,"K" 12.35K Here is a conditional number format that shows numbers as millions with an M, thousands with a K, or as numbers: [>=1000000]0,,"M";[>=1000]0,"K";0 Here is how some numbers appear in this format: Number As displayed using 0.1 0 1 1 10 10 100 100 1,000 1K 10,000 10K 100,000 100K 1,000,000 1M 10,000,000 10M 100,000,000 100M 1,000,000,000 1000MThousands, Millions, etc.
[>=1000000]0,,"M";[>=1000]0,"K";0
Thursday, July 15, 2010
Number Formats in Microsoft Excel
Tuesday, March 9, 2010
40句让你看了会心痛的话
1、你突然点醒了我，我们的相识能够以年计算了，你找到你爱的，而我，还在原地徘徊着。
2、如果我从没遇见你，如果我从没爱上你，如果我一开始没坚信，也许我就不会是现在的这个自己。
3、你变了，我也变了，回不去的温柔，泪水如泉涌，最熟悉的变得最令我心痛。
4.情断了，绑不住，试着放手，走与不走，留与不留，我不想懂。
5.明知你心里没有我，也永远做不到你想要得那个，却不由自主让你看到最真实的我，掩藏住受伤的我。
6.当一切都回不去了，当我决定要走，你才明白冷落了我，我要的不多，可你都没给够，哪怕一个温柔的相拥，对我来讲，都是幸福的。
7.如果爱不曾来过，如果梦不曾碎过，如果心不曾疼过，那么我，是否还是你认识的我？
8.别害怕，我一直站在你的身后，总在你呼唤时守在你左右。
9.不要走，请逗留，不要再让我心痛，难道你认为伤我还不够？
10.不要再折磨我，我的心已被割破，流尽的不是血，是爱你的错。
11.诺言不过上一种谎言，那是种美丽的欺骗，可就是有人愿意为了它放弃一切.
12.你就像我口中的牛奶，我渴了，饿了，困了，累了，你却帮不了我什么，只上一暂时滋润了。
13.野猫的女人很任性，他们倔强不失可爱，野蛮不失温柔，他们认定的东西，就算不要、也不能让别人拥有，她们是贪心的，因为她们害怕寂寞。
14.擦肩而过，你我，并不是属于彼此的，无所谓的珍重与再见，无所谓的感受与苦涩已化作尘埃飘过，我们该珍惜现在。
15.窗外雨在下，一颗挨着一颗，我的泪水也蓬勃了，如窗外那断了线的雨珠。
16.当温柔不在，当泪水擦干，我现在的挽留还算不算？只愿不会成遗憾。
17.喜欢就喜欢了，心被牵动，无须理由，爱上你是我的自由，请打开窗口，让我的灵魂与你的灵魂相拥。
18.说过不会比你先走，说过就算走也决不回头，说过不再用手试泪，说过就算你走也不在原地逗留，说过的不在也再，说过的一切已不算，你的臂弯已不再是我心灵的港湾，而那些承诺不过是无稽之谈。
19.想爱不能爱才最寂寞，我试着勇敢一点，可我无法面对镜中颤抖的双眼，所以只能跟靠近我的每个人说再见。
20.走，还是要走的的，留下来的不过是一副躯壳，留，还是要留的，我的心就在次生根了。
21.孤独的双眼沉默着，何时才被明亮发现，躲在黑暗角落的我
22.你的寂寞让我留恋，不小心回头看了你一眼，只有孤单的人会寂寞。
23.淡了，散了，不多，一点就够了，睡了，呼呼中，懂了？是的。
24.梦已逝，心已碎，留下只是在为离开做准备。
25.如果不要我，请离开我，留下，只是继续令我难过。
26.如果我能够继续等待，如果时间能够停留下来，如果……没有如果？
27.断了联络，断了思念，最后的希望已灰飞湮灭，心已疲倦，痛吗？不懂。
28.擦去脸上的泪水，却带不走心中痛楚的感觉。
29.爱就爱了，接受拒绝？简单的几个字却变了味，你无言的回应，我逃避的闪躲，为何？正面回答不会比现在更伤害我。不要坚信，他没回应总好过答应了无法承诺，那样心更炙热，他给不起，你还要吗？
30.愁绪吗？有点闷，一点孤独品尝一点寂寞。
31.天空开始放晴，微风划过，如此轻柔，想每次你偷亲我的脸颊一样，我笑了，仅仅是因为想起了你。
32.有点落寞，我不懂该怎么说，让它在无声中逝去，我走了，其实它没有来过，只是夜晚心异常柔软。
33.当我流着泪向你说再见，你只是冷漠的向我告别，不感看你的冷漠的眼，心已碎成千片。
34.我难道的时候你在哪里？心痛的感觉令我麻痹，痛得我难以呼吸，却不敢告诉你。
35.你的心已不属于我，可我却还期待你的回应，明知不可以，却还是被牵引。
36.爱来过，也走过，痴过也恨过，伤过才会懂，一切皆是错。
37.电话那头，又是沉默，该放手，却难割舍。
38.每到夜深人静，我才倍感寂寞倍感心酸，孤单的人心易碎，总是看到别人双双对对，才感觉，一个人好孤单，只是真心已不在，真心已不算。
39.当依靠的肩膀不在，当我的眼泪流干，当我决定放手，我的心已不在。
40.我难过的时候你在哪里？一句抱歉就能把空白代替?
Monday, March 8, 2010
RemoveWAT 2.2.5 - Windows 7 Activator + KB971033 Fix
RemoveWAT 2.2.5
For Windows 7/Server 2008 R2/Windows Home Server 2010 or later by Hazar
Update on : 26 Feb 2010
Info :
WORKS ON ALL EDITIONS OF 7/2008R2/HS2010
NOT FOR VISTA/ORIGINAL SERVER 2008!!!!
IMPROVEMENTS SINCE 1.0:
- renames slmgr on x64 as well
- Works on unicode systems
- silent mode with /s switch
- UI tweaked slightly
- No reboot necessary
- Passes WGA on X64
There will be no windows activation section in control panel
no slmgr,no nags, no prompts, nothing. WAT gone. .
In theory this should have a 100% success rate on all machines.
- Hazar
Version 2.2.5
Update:
Fully protects from WAT Update (KB971033)
Disables trial time bomb in evaluation ISOs fully
Installion and Use:
1. UnRAR
2. Run as Adminstrator
3. Click on Remove WAT button
Enjoy !!!
To Return Windows 7 to Original State:
1. UnRAR
2. Run as Adminstrator
3. Click on Restore WAT button
KB971033 - the fix for Windows Activation Technology bypass/cracks.
The best thing to do is not to download the KB971033 update.
But if u already updated it and the system said that it is not genuine,
Just run the removeWAT, and it will return back to normal
For those who still run W7 RC and get error the PC restarting by itself,
Upgrade to 7600 RTM version.
How to Check Which Version of Microsoft® Windows® You Have
1. On the taskbar at the bottom of your screen, click Start
2. Then click Run.
3. In the Run dialog box, type winver
4. Click OK
5. A dialog box displays the version that you are running
Follow this tutorial if your PC keep restarting
Screenshots : 
Download :
RemoveWAT 2.2.5
http://www.mediafire.com/?yynznmij2da
http://www.megaupload.com/?d=QERH3YMV
Saturday, March 6, 2010
How to Remotely Restart a Windows Machine Through Command Line
The DOS command line built into every windows machine can be used to perform a lot of useful tasks. One very helpful task is shutting down your computer. By working your way through a few simple steps, you will find that you are able to easily shut down or restart your computer.
1. Make sure you have an administrative rights on the remote machine and you can PING it.
2. On your workstation - Click on Start > Run, Type shutdown -i
3. select options to shutdown or restart
4. Alternatively - Go to command prompt (start > run > cmd) on your workstation... and Type
shutdown -r -m \\xxx.xxx.xxx.xxx
Replace xxx.xxx.xxx.xxx with the IP address or computer name of the remote machine. -r option is for restart, don't use -r if want to just shut down the system.
Wednesday, March 3, 2010
網盤資源搜索技巧
国外网盘链接搜索的网站整理合集，再重新回顾一下吧：
1. RapidShare1 - Rapidshare Search Engine
2. RapidShare Searcher - Search in rapidshare.com
3. FileZ - Rapidshare Search - File Search
4. LoadingVault - RapidShare Search
5. RapidOSearch - RapidShare Search Engine
6. Rapidoogle - The RapidShare Search Engine
7. HellaFiles - Rapidshare and Megaupload Search Engine
8. RapidShare-Search-Engine - Find files on rapidshare
9. FileCrop - Find Rapidshare & Megaupload files
10. ThuVienPHP - RapidShare Search Engine from Vietnam
11. RapidZilla - Your rapidshare.com search engine
12. OplaHol - We find any file for you
13. FileSearch - Advanced Search Engine for Rapidshare Files
14. FileScoop - Makes File Searching a Snap
15. FilesBot - File Storages Search Engine
16. SearchFiles.de - The Premium File Search Engine
17. OneClickFiles - Search for files on rapidshare, megaupload, etc
18. SearchShared - Search Shared File Servers
19. FilesTube - Every search is a direct hit
20. Rapidfox - RapidShare Search Engine
21. ShareMiner - Search Files on Rapidshare, Megaupload, SendSpace, ZShare
22. ShareDigger - File Search Engine
23. Share4VN - Download Everything You Need!
24. JuSearch - File Hosting Search
25. Avun - File Hosting Search
26. FilesHunt - Rapidshare Search Engine
27. MEGAPID - Official RapidShare Search Engine
28. TotMe! - Rapidshare Search Engine
29. FileSearch - Rapidshare and megaupload file search engine
30. MegaDownload - Megaupload and Rapidshare search engine
31. RapidLibrary - RapidShare Search Engine
32. RapidAll - Rapidshare and others Web Host download Search!
33. RapidSearch.CA - RapidShare Search Engine
34. Gappon - Your Rapidshare, megaupload, mediafire search engines
35. Search4File - Free file search on RapidShare, Youtube and more
36. NewRapidHunter - The easy way to find rapidshare files
37. LoadEvery - More than Search!
38. FileField - Search for files download
39. Leecha - Get it while it’s hot
40. RapidShareIndex - Rapidshare Search Engine
41. RapidRat - RapidShare Search Engine
42. RSDown - Rapidshare links search engine
43. Search.jrfreelancer.com - File Search Engine
44. Sharech - Search for files on the best servers download
45. RapidBurner - RapidShare Search Engine
46. RapidshareDATA - RapidShare Search Engine
47. Search Rapidshare and Megaupload
48. SharingEngines - Search rapidshare megaupload torrents emule mp3 movies
49. QuickSearch - Find needed files from RapidShare Links
50. Funfail - File Search
51. InfoBind RapidSearch
52. 4Chan - RapidShares
53. MegaTao - RapidShare RssSearch
54. RapidExplorer - RapidShare Megaupload Search Engine
55. Busca-RapidShare - Buscador de Rapidshare
56. DownloadList - Download RapidShare Search Engine File
57. rsSearch - Rapidshare Search Engine
58. Rapidor - RapidShare Search Engine
59. RapidSearch.in - Rapidshare links search
60. UVRX - Internet Search
61. BioScience - Search Shared Files
62. ShowIP - RapidShare Search Engine
63. Rapidshare Meta search engine
64. Rapidwolf - RapidShare Search Engine
65. FindAnyLinks - RapidSearch and Other Hosts Download Links Finder
66. RSFilez
67. Jwagal - Rapidshare search
68. Search Rapid Share . net - RapidShare Search Engine
69. RapidSearchLinks - The easiest way to share your file around
70. Megaxo - Search RapidShare, Search MegaUpload
71. DDL Search - Rapidshare search engine
72. RapidSurfing - RapidShare Search Engine
73. Rapidsharelink - Rapidshare Search Engine
74. JamesWatt - RapidShare and Megaupload Search
75. RapidLinks - Locate Your Links Rapidly
76. FreeXFile - Your RapidShare Search Engine
77. 890m rapidshare download search
78. RapidZero - Rapidshare Search Engine
79. DiggRapidShare - Search Your RapidShare Files
80. EliteSearch - Direct Download Search Engine
81. SharingRapid - Search rapidshare megaupload and more
82. 5iles - The Best Search Engine
83. INetList.com - Your RapidShare Search Engine
84. Search-File
85. PakAdTrader - Rapid Search
86. Shared File Searcher
87. LiveThunder Files
88. ShareMinerScript - My Query Builder
89. Medianet - RapidShare Search Engine
90. RapidShareFinder
91. FNETS - Search Rapidshare Files
92. ShareYard Search
93. HuHiHo - Universal File Search
94. goinFiles
95. Yourfile.US
96. GoFileZ File Search Engine
97. RSFind - RapidShare Files Search
98. RapidSeek - Search Shared Files
99. Rapid2Share - RapidShare Search Engine
100. RapidMe - RapidShare Search Engine Software
101. RapidSeek .NET Pro 2007 - Seek links to files on RapidShare network software
102.http://www.rapidshare8.com/ 中国人做的rs搜索引擎
Lady Gaga - The Remix - 03.03.2010 - JAPAN
Artist: Lady GaGa
Album: The Remix
Release Date: 2010.03.03
Size: 147Mb
Bitrate: 320 kbps / 44.1kHz / Stereo
tracklist:
------------------------------------------------
01 Just Dance (Space Cowboy Remix)
02 Just Dance (RedOne Remix)
03 Porker Face (Space Cowboy Remix)
04 Porker Face (LLG Vs GLG Radio Mix)
05 Eh,Eh (Nothing Else I Can Say) (Electric Piano And Human Beat Box Version)-The Cherrytree Sessions Version
06 Eh,Eh (Nothing Else I Can Say) Pet Shop Boys Radio Remix
07 LoveGame (Space Cowboy Remix)
08 LoveGame (Chew Fu Ghettohouse Fix feat.Marilyn Manson)
09 Paparazzi (Yuksek Remix)
10 Paparazzi (Stuart Price Remix)
11 Bad Romance (Skrillex Radio Remix)
12 Bad Romance (Starsmith Remix)
13 Bad Romance (Kaskade Main Remix)
14 Telephone feat.Beyonce (Alphabeat Remix)
15 Telephone feat.Beyonce (Passion Pit Remix)
16 Telephone (Crookers Vocal Remix)
http://freakshare.net/files/xce3ndsi/Lady.GaGa.The.Remix.JP.rar.html
Tuesday, March 2, 2010
Panda Cloud Antivirus Free Edition 1.0.1
(March 1, 2010)
Windows Vista/XP / Freeware / 3,286 downloads
Panda Cloud Antivirus is the first free cloud-based antivirus thin-client. It consists of a lightweight antivirus agent that is connected in real-time to PandaLabs' online Collective Intelligence servers to protect faster against the newest malware variants while barely impacting PC performance. Thanks to Panda Security's Collective Intelligence malware and goodware online database, Panda Cloud Antivirus detects more malware than traditional signature-based solutions which take longer to detect the most recent, and therefore most dangerous, variants. Panda Cloud Antivirus protects you while you browse, play or work and you won't even notice it. It is extremely light as all the work is done online in the cloud. Panda Cloud Antivirus provides you with the fastest protection against the newest viruses thanks to its cloud-scanning from PandaLabs' servers. Panda Cloud Antivirus is truly install and forget. Don't worry about updates, configuration or complicated decisions ever again.
Title: Panda Cloud Antivirus 1.0.1
Category: soft
Developer: Panda Software
Year: 2010
File Size: 22.63 Mb
about: Panda Cloud Antivirus can detect and block threats more effectively than do traditional antivirus programs, from the total displacement process detection and scanning of malware in the "cloud", as well as through the use of technology in the architecture of the client intercepts, not affecting the main mode.
With its ultralight agent product practically does not consume PC resources. This Panda Cloud Antivirus provides enhanced protection against new and unknown viruses. Traditional antivirus products for PCs based on multiple, locally installed technology that intercepts every file on different levels (vector input, the file system and execution) and scan it using different modules (antivirus, heuristics, intrusion prevention, behavioral analysis, etc.) .
As a result of this process consumes a large amount of local memory of the PC and CPU resources, which is extremely negative impact on PC performance. Agent Panda Cloud Antivirus brings a new philosophy of asynchronous scan in "the cloud" on the fact of access. It combines the technology of the local detection with scanning in the "cloud" in real time for maximum efficiency with minimum resource consumption. This optimized model blocks malicious programs when you try to run past its execution.
On the file:
Enabling | reg code: not required
File format: rar
Platform / OS: Windows ® 98/ME/2000/2003/XP/Vista/7
http://rapidshare.com/files/357663550/Panda_Cloud_Antivirus_1.0.1.rar
http://www.2shared.com/file/11779974/aef7432c/Panda_Cloud_Antivirus_101.html
http://www.4shared.com/file/232520384/4fcacc7/Panda_Cloud_Antivirus_101.html
http://www.gigasize.com/get.php?d=s1dc10o5xfb
http://hotfile.com/dl/30779176/f9daafb/Panda20Cloud20Antivirus201.0.1.rar.html
http://www.badongo.com/file/20919513
http://depositfiles.com/files/7v9rrm3y0
http://evilshare.com/fu7p0w3nig40/Panda_Cloud_Antivirus_1.0.1.rar.html
http://freakshare.net/files/nsekvfyz/Panda-Cloud-Antivirus-1.0.1.rar.html
