DataFormatString with zeros

[Attila]

Hi,

I would like to use DataFormatString in my radgrid to convert numbers:
DataFormatString="{0:# ### ###}"
It's working perfectly with numbers like 54210 = 54 210.
But it's not working with zeros (0).

Also what can I do with negative numbers? Now it's like -54210 = - 54 210. I want it to be -54 210.

How can I fix this?

Thanks!

[Eyup]

Hello Attila,

Can you please provide us several more samples demonstrating the desired formatting? Thus, we will try to come up with viable solution to match your scenario using the following resources:
http://msdn.microsoft.com/en-us/library/dwhawy9k%28v=vs.110%29.aspx
http://msdn.microsoft.com/en-us/library/0c899ak8%28v=vs.110%29.aspx

Looking forward to your reply.

Regards,
Eyup
Telerik

 

 

[Attila]

Hello Eyup,

Here are some samples:
I want a seperation in every thousand.
So
123 = 123
1234 = 1 234
12345 = 12 345
123456 = 123 456
-12345= -12 345
-123456 = -123 456
and 0 = 0

I got nothing for zeros and for "-123456" i get "- 123 456"

Regards,
Attila

[Konstantin Dikov]

Hi Atilla,

RadGrid uses the String.Format method for applying the DataFormatString and the issues that you are experiencing are related to the way that you current format is applied. You test the String.Format method and you will see the following result with the format you are specifying:

• string.Format("{0:# ### ###}", 0) = " "
• string.Format("{0:# ### ###}", -54654) = "- 54 654"
  string.Format("{0:# ### ###}", -54654)string.Format("{0:# ### ###}", -54654) = "- 54 654"
  

Since the result you are observing are not related to our controls, please refer to the MSDN article for custom formats and change your format accordingly, so it could fit your exact requirements:

• Custom Numeric Format Strings

Best Regards,
Konstantin Dikov
Telerik