O'Reilly logo

Excel 2010 Financials Cookbook by Andre Odnoha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Redefining the data format

As evidenced throughout the recipes so far, data may be received in varying formats, and may need to be changed prior to being sent elsewhere. This need for modification becomes increasingly important when sharing financial data internationally. Countries differ in method in which data is displayed, such as dates.

In this recipe, we will modify date information to display this and other information differently.

How to do it...

  1. Select the column that contains the date to be modified by selecting the column header:
    How to do it...
  2. After the column has been selected, right-click on the column header and choose Format Cells:
  3. From the Format Cells ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required