# Standardize Cell Formats

This options enables the standardization of cell formats within Microsoft Excel files. KeyView formats any cell where a number has been entered according to the following rules.

## Numbers

These include:

- rounded numbers
- exponentials
- fractions
- percentages

Numbers are printed to the maximum length entered–that is, the full number put into the cell, without any rounding. Negative numbers are printed with a dash in front of them (as opposed to, for example, bracket form).

## Text

All text that is part of the format string is stripped, including currency symbols.

## Dates

All dates are printed in full ISO-8601 format (that is `YYYY-MM-DDTHH:MM:SS`). There are two exceptions to this rule:

- Cases where the date format contains a time delta (that is, `"[h]"`, `"[m]"`, or `"[s]"`). In this case, the time is displayed as an interval, which is the number of days (where a day is defined as a period of 24 hours). The time is printed in the ISO-8601 time interval form, for example `P1.234D`.

- Cases where the absolute value of the cell is less than `1.0`, and the date format contains only time components. In Excel, values between `0.0` and `1.0` correspond to the fictional date `1900-01-00`, and are used to express times without an associated date. For example:

  Value | Date format | KeyView output
  --- | --- | ---
  `0.5` | `hh:mm:ss` | `12:00:00`
  `0.5` | `dd hh` | `1900-01-00 12:00:00`
  `1.5` | `hh:mm:ss` | `1900-01-01 12:00:00`
  `1.5` | `dd hh` | `1900-01-01 12:00:00`

  You can enable this option by adding the following to the `formats.ini` file:

      [Options]
      StandardizeCellFormats=TRUE

  Alternatively, iyou can enable this option programatically by passing `KVFLT_STANDARDIZECELLFORMATS` to `fpFilterConfig`.

© Copyright 2016-2020 Micro Focus or one of its affiliates | Send documentation feedback Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a mail client, and then send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm