Formating

Question

Hi all,

I have the following data

23345
435657
2122

how can i get this format


23,345
435,657
2,122

pleasee help me?

Answer 1

if you want to show in Reporting services then there is a format tab on text box....is it in T-SQL?

Answer 2

Hi,

Try this


= FORMAT(Fields!Number.Value, "N0")

---

Rajesh Jonnalagadda http://www.ggktech.com

Answer 3

Try writting in the expression Fields!X.value where X is the name of the field.

Selecting the cell clic the right button of the mouse and select properties. In the format tab and in the format code field write N3

good luck!

Answer 4

Hello,

You can get this as suggested by Rajesh.

The same in a different manner is as follows:

1. Go to the cell and right click and go to the properties window.

2. In the properties window go to the Format Tab.

3. In the format tab select the Custom Format radio button.

4. In that place N0 as the format code.

Hope its clear...

---

Pavan http://www.ggktech.com

Answer 5

I think Rajesh and Pavan are right, I misunderstood the question.