How to convert time values into decimal values in Excel Internally, Excel stores the time as a decimal value. The quickest way to see that time value is to change the format.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.

If you use Microsoft Excel's "Set Precision as Displayed" option, the program uses the number of decimal places you allow your worksheet to display as the actual values in its calculations.

How Can I Merge Two Columns of Data Using Microsoft Excel and Eliminate Duplicate Values?. There are two situations in which you might need to merge two columns of data in Excel 2013.