Please use the custom pattern as #’##0.00 for numbers up to 999,999, #’###’##0.00 for numbers from 1,000,000 to 999,999,999 and #’###’###’##0.00 for numbers from 1,000,000,000 to 999,999,999,999. Please check following piece of code to achieve the same using Aspose.Cells for .NET API.
As I narrated earlier, you will have different pattern for different length of values. In this case, the value is shorter than a thousand so you will adjust the pattern accordingly. By the way, best way to deal with such scenario is to either change your system’s regional settings to a region where single quote is a thousand separator (this will apply to all applications) or override the settings in Excel application only while using the File > Options > Advance > Editing Options > Thousand separator. You have to deselect “Use system separators” option in order to override these settings.