Standardize Cell Formats

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

Numbers

These include:

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:


_HP_HTML5_bannerTitle.htm