Saturday, April 5, 2014

Evernote: Offline Notes in IOS device

First you need to pay for Premium account in Evernote.
Offline Notebooks: you can access you notes even you don't have Internet connection.

How to ?

Add your note to favourite (by click the star), then you can access the note even offline.


Tuesday, April 1, 2014

MS Excel 2011 -- Change Date Time field to Date

Change the date time field to date, do the following in the cell

=Text(B2, "yyyy-mm-dd")

B2 is the cell with date time field.