5
The NumberFormat field on the Excel Buffer table is used to define the formatting string that will used for any given cell in Excel. The field is currently 30 characters long. The longest "standard" custom format in excel is 49 characters long and is _-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-

This format produces a leading minus sign, dollar sign, comma separated thousands, always two decimal places and dash for 0.

The format string also supports the ability for conditional colouring (such as making negative numbers red). Please increase the size of this field to allow more options. At the very least it should be increased to 50 characters, but ideally it will be increased to 250.
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team