Adsense
Popular Posts
- MySQL workbench -"Could not decrypt password cache"
- mod_auth_cas.so error: undefined symbol: SSL_connect
- JavaScript, remove trailing insignificant zeros after toFixed function
- Set Windows path command line
- JavaScript Arrays and Associate Arrays
- Design date and signature box in Latex
- Install APXS in Redhat Linux
- super(props) in React
- jQuery, toggle the display
- PHP function for input sanitizing
Showing posts with label EXCEL. Show all posts
Showing posts with label EXCEL. Show all posts
Tuesday, June 17, 2014
FileMaker and EXCEL date format to MySQL
I export Filemaker database to EXCEL (.csv) and upload it MySQL in PHPMyadmin.
The date format in Filemaker and EXCEL is: dd/mm/YYYY,
while in mySQL: YYYY-mm-dd
It is difficult to change date format in Filemaker to MySQL.
It is easier to change the date format in EXCEL
1) Right click date column in EXCEL, go to Format Cells and then the Number tab.
2) Select Date
3)Change the Locale to English (U.K.), default is English (USA) and you can not find MySQL date format
4) The fifth item on the list 2001-03-14 is the format for MySQL.
Friday, June 13, 2014
EXCEL return to the next line in the same cell
To return to the next line in the same cell in EXCEL:
hold down the ALT key, and then press enter.
Thursday, June 5, 2014
EXCEL, merge multiple cells for title or descriptions
To merge multiple cells for title or descriptions in EXCEL
1) select multiple cells
2) Under top menu, Merge & Center, select "merge cells"
3) Type your text
3) To change background color of the text
Go to "Fill color" at the top menu, select color.
Subscribe to:
Posts (Atom)