We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

''Space'' as currency delimiter

Thread ID:





99131 May 2,2011 05:29 AM May 3,2011 03:17 AM ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Marcus Olsson
Asked On May 2, 2011 05:29 AM


How do I set the 'space' character as a delimiter when formatting a cell?

I tried the following:

sheet.Range[row, col].Value = "123000000000000000";
sheet.Range[row, col].NumberFormat = "# ##0";

But this results in:

123000000000000 000

and the desired result is

123 000 000 000 000 000

When inspecting the applied format it has actually been set to
"#\ ##0"
where the backslash seems to cause the problem. When removing the backslash the correct format is applied.
Why is the backslash added and how do I solve it?

Sridhar [Syncfusion]
Replied On May 3, 2011 03:17 AM

Hi Marcus,

Thank you very much for using Syncfuion products.

We have tried with MSExcel to set space delimiter in Custom format and it belongs to Accounting type format.
In Currency format type we are not able to set 'space' delimiter.
We can set the Number formats and Text format types of the cell with 'space' delimiter.

Here, we are unable to set the 'space'delimiter for the number format using XlsIO, and this can be suspected to be an issue.
We have forwarded to the development team for more analysis.

So we request you to open a new direct-trac incident with a simple issue reproducing sample for further follow up on this issue.

Direct-Trac Link:


The backslash(\) used to display any character other than "space" in between the numbers in XlsIO.

Please, let us know if you require any further clarifications.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.