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

Comments


  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

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

    best interiors

    ReplyDelete

Post a Comment

Popular posts from this blog

Hadoop - Hive - Load data from csv/xls files

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