1,438 reputation
415
bio website
location Hong Kong, Hong Kong
age
visits member for 2 years, 11 months
seen 2 days ago
stats profile views 62

Feb
4
comment Rounding in Excel
cpast's edit changed the meaning of the question.
Jan
7
answered Microsoft excel formula on rounding up values
Dec
19
awarded  Popular Question
Dec
17
answered Excel: Check if column A has any values from Column B, and delete that value from Column A
Nov
16
comment How to change the delimiter when you copy from Excel and paste to notepad
Refer to my answer in another question: superuser.com/questions/206060/…
Oct
30
comment Exporting a subset of an Excel sheet as a (clean) HTML tab
@jakobengblom2 Inspired by your mention on MediaWiki, here is an interesting solution. Copy the desire range in Excel, then paste it to ckeditor.com/demo. Click "Source". (Quite clean) HTML codes are right there. (You can use other WYSIWYG editor with view source function). If it is a good solution, let me know and I will put it as answer.
Oct
24
comment Is there any way to replace “|” (L) character to “I” (i) with notepad++?
What do you want? It seems that your question means L to I & l to i? But your example means l to I...
Oct
19
answered How to create a random string of random length from the alphabet?
Oct
19
comment How do I separate words in notepad++, Excel or similar?
You have to let us know the general format of your data for you to get suitable answers.
Oct
15
comment Conditional formatting Excel 2007/2010: Highlight the first cell in the row that contains duplicate values?
+1. Seems that the appropriate range should be B3:G3 instead of B3:E3.
Oct
15
comment Why does pinging 192.168.072 (only 2 dots) return a response from 192.168.0.58?
it is useful for RGB HEX to DEC conversion. lol~ C:\>ping 0xffffcc Pinging 0.255.255.204 with 32 bytes of data:
Oct
12
answered I can't write credit card number when I write the last number becomes 0
Aug
28
comment Excel's date format without a year
If you don't want to put 2012, I would rather suggest you to keep date format, but put 1900. Date format is good in case calculation is needed in the future.
Jul
25
revised Grouping labels and concatenating their text values (like a pivot table)
added 53 characters in body
Jul
25
revised Grouping labels and concatenating their text values (like a pivot table)
added 49 characters in body
Jul
25
answered Grouping labels and concatenating their text values (like a pivot table)
Jul
25
comment Vertical line for the the right margin in Notepad++
Tested and still valid in v6.1.5
Jul
20
awarded  Yearling
Jul
10
awarded  Caucus
Jun
23
answered Getting consistency in the colour of cells in excel