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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

''Space'' as currency delimiter

Thread ID:





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


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 07:17 AM UTC

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.

Please sign in to access our forum

or the page will be automatically redirected to sign-in page in 10 seconds.

Warning Icon 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.Close Icon