MS-Excel -trick to format the data

Most of our day to day work we need to use MS-Excel to summarize or calculate some business data. We may have to bucket these data into various format. For e.g I need to analyze last year sales data month on month but the date should be in this particular format YYYY-MM-DD and the format of the same in spread sheet is in this format YYYYMMDD.

We can change the format by two methods-

1. add custom format by right clicking and select custom option

Fig 1

give the required format here as showed in Fig 2 which enables to use the same format easily in other part of the excel as well.
Fig 2

2. second option is very easy like any other formula in excel

Fig 3


Post a Comment

Popular posts from this blog

Microsoft BI Implementation - Cube back up and restore using XMLA command

Databricks - incorrect header check