@param format Pointer to a Format instance.
@param num_format The cell number format string.
This method is used to define the numerical format of a number in
Excel. It controls whether a number is displayed as an integer, a
floating point number, a date, a currency value or some other user
defined format.
The numerical format of a cell can be specified by using a format
string:
@code
format = workbook_add_format(workbook);
format_set_num_format(format, "d mmm yyyy");
@endcode
Format strings can control any aspect of number formatting allowed by Excel:
@brief Set the number format for a cell.
@param format Pointer to a Format instance. @param num_format The cell number format string.
This method is used to define the numerical format of a number in Excel. It controls whether a number is displayed as an integer, a floating point number, a date, a currency value or some other user defined format.
The numerical format of a cell can be specified by using a format string:
@code format = workbook_add_format(workbook); format_set_num_format(format, "d mmm yyyy"); @endcode
Format strings can control any aspect of number formatting allowed by Excel:
@dontinclude format_num_format.c @skipline set_num_format @until 1209
@image html format_set_num_format.png
The number system used for dates is described in @ref working_with_dates.
For more information on number formats in Excel refer to the Microsoft documentation on cell formats.