Overview

 CellTypeDisplay FormatEditing FormatInput Column
1CurrencyCellTypeCurrency Sign:USDCurrency Sign:$USD12,345
2DateTimeCellTypeFormat:MMMM dd, yyyyFormat:MM/dd/yyyyOctober 27, 2020
3DoubleCellTypeGroup SeparatorNo Group Separator12,345.6
4IntegerCellTypeNegative Sign:~Negative Sign:@~12
   

You can not set the format while the cell is in edit mode.


Prior to V7, data in edit mode is not formatted. It stays plain until the user press Update button. Now, version 7 has a new feature called "Edit mode format support" enabling user to either set a NumberFormatInfo or DateTimeFormatInfo to cell values in edit mode, thus user experience is improved.

Documentation