Wanwisa's Blog

You have number of second and want to convert into minute format. Use this function. Replace you value in this function: =INT( value /60) & ":" & TEXT(INT(MOD( value ,60)), "00") For example: =INT(H4/60) & ":" & TEXT(INT(MOD(H4,60)), "00") Note that 'H4' is cell in Excel. The value will be: 603 Seconds will be shown as 10:03

Normally, you will use TAB in Word Processing to help increasing indent and use Shift+TAB to help decreasing indent. Somehow, you mistyped something and TAB is no longer help to increase or decrease the bullet and numbering anymore without Microsoft Word noticing you. To set it back for Microsoft Word 2010, please follow these steps: - Select 'File' -> 'Options' - In 'Word Options' window, select 'Proofing' and then 'AutoCorrect Options...' button. - In 'AutoCorrect' window, select tab 'AutoFormat As You Type', check at 'Set left- and first-indent with tabs and backspaces' and then click 'OK'.

When you connect to Oracle server from your PC and can't read Thai, normally it's because you didn't set NLS Language to be the same as the Oracle server. To use Thai language, suppose that the Oracle server is already set NLS Language to support Thai using this value: NLS_LANG = THAI NLS_TERRITORY = THAILAND NLS_CHARACTERSET = TH8TISASCII From your PC, - Click at 'Start' button, at the search box, type 'regedit' and ENTER to open "Registry Editor". - Inside "Registry Editor", drill down 'Computer' -> 'HKEY_LOCAL_MACHINE' -> 'SOFTWARE' -> 'ORACLE'. - Under 'ORACLE', click at 'HOME0' at the left panel. - In the right panel, double click at 'NLS_LANG', input value 'THAI_THAILAND.TH8TISASCII' and click 'OK'. - No need to restart the computer. Just close the client program and open it again.

This is the way to add e-Mail account into Thunderbird. Currently, I'm using Thunderbird 3.1.5 to demonstrate. - From the menu bar, select "Tools" and then "Account Settings...". - At the "Account Settings" window, there is a "Account Actions" dropdown list at the bottom left, click and select "Add Mail Account...". - At "Mail Account Setup" window, enter    1) "Your name" = Your name    2) "Email address" = Full e-Mail account    3) "Password" = Your password    4) Check at "Remember password" to let Thunderbird remember it.    Then, click "Continue" button to continue. - Thunderbird will try to find common e-Mail server name for you. But this case it found IMAP protocal. Click "Edit" to change to POP. - Change the values    1) "User name" = Full e-Mail address    2) "Incoming...

To remove oily face, I use Photoshop 7. - Open Photoshop and your picture file. - Select 'Clone Stamp Tool (S). - Select 'Mode' to be 'Darken'. This option is to make it effect only the area that it's brighter. - Decrease 'Opacity' to be around 50% to adjust the colour bit by bit. - Select 'Softround Brush' in the size you are convenient to. - Select the point that close to the bright area by press 'ALT'+ 'Left Click'. - Then click at the brighter area to adjust the photo. - Result to compare before and after. Before: After:

document.getElementsByTagName("form")[ i ]. . = ; i = [0..n] value = text or boolean or etc. Example: document.getElementsByTagName("form")[0].order_num_users.disabled = true;

To enable Cookies in FireFox is not easy to see. So, please follow these steps. - From the menu, select "Tools" -> "Options...". - In "Options" dialogue box, click at "Privacy" tab. In "History" section, "Firefox will:", select "Use custom settings for history". - Check "Accept cookies from sites" and then click "OK".