Excel Guides

Creating Two-Line Custom Formats in Excel

When it comes to creating custom formats in Excel, there are a few things you need to keep in mind. First, you need to decide what your format will look like. Second, you need to choose the cells that you want to format. And third, you need to create the format itself.

When it comes to deciding what your format will look like, there are a few things you need to keep in mind. First, you need to decide what your format will look like. Second, you need to choose the cells that you want to format. And third, you need to create the format itself.

When it comes to choosing the cells that you want to format, there are a few things you need to keep in mind. First, you need to decide what your format will look like. Second, you need to choose the cells that you want to format. And third, you need to create the format itself.

Once you've decided on the cells that you want to format, it's time to create the format itself. To do this, open up the Format Cells dialogue box by going to Home >> Styles >> Format as Table >> Select Table.

In the Format Cells dialogue box that appears, select the Custom category from the list on the left-hand side. In the Type field on the right-hand side, enter the following code:

[$-809]dddd\ mm\ yyyy

This code will ensure that your dates are displayed in a dd/mm/yyyy format.

Click OK when you're done and your custom date format will be applied!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.