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


  1. You write this post very carefully I think, which is easily understandable to me. Not only this, but another post is also good. As a newbie, this info is really helpful for me. Thanks to you.
    Tally ERP 9 Training
    tally classes
    Tally Training institute in Chennai
    Tally course in Chennai

  2. Extremely decent review. I totally appreciate this site. Much obliged!

    best interiors


Post a Comment

Popular posts from this blog

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

Databricks - incorrect header check