TFlxFormat.Format

How to determine the format of the cell. 

What values can return TFlxFormat.Format.


Hi,

TFlxFormat.Format returns a string with the numeric format of the cell. the string is always in English, and it is a standard Excel formatting string.

The format is defined here: https://support.office.com/en-us/article/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68

But remember that you can always use APIMate to find out what a given format is. Just format the cell as you want in Excel, save the file, open it in APIMate, and it will tell you the numeric format you used.