Category Archives: Office

Set Units of Measurement to Inches or Centimeters in Excel 2013/2016

By | January 26, 2018

By default, Excel takes units of measurement from the system settings. Sometimes, however, these settings are not the ones we want to use in Excel. The good news is that these units can be changed in Excel settings without having to intervene in the system configuration. Here’s how to do it. On the ribbon click File tab On… Read More »

Getting current Date and Time in Excel 2010/2013/2016

By | December 2, 2017

There are two functions which you can use to get current Date and Time in Excel: =TODAY() and =NOW(). You can use these functions as part of a text string by putting them into TEXT function with formatting string. It’s important to note that both of those functions are automatically recalculated each time you change or open your… Read More »