When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.

If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.

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

The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.