How to make 4952971.2 display as 4,952,971.3 ?

[paulyeo11]

Hi All

I like to make the above . See my QV Doc.

Paul

[avinashelite]

Hi Paul,

Go to properties> number > define the format

[amit_saini · Accepted solution]

Paul,

See the attachment.

Thanks,
AS

[sujeetsingh]

Use num(() function.

[vardhancse]

We can change the number format for the data.

take for eg: if the value is displaying in the list box->properties->number->select the field

change the format.

[tresesco]

Use Ceil() like:

=Ceil(4,952,971.2, 0.1 )

[#7]

Hi Paul,

Use num function as

=num( Your Expression  , '###,###,###.#')

Write your expression within the bracket.

Hope this will help you in displaying result in text box also.

- Lalit

[qlikpahadi07]

Hi Paul,

in your text box just write Num(<Expression>,'#,##0.0')

[paulyeo11]

Many thank for all the reply. I will try it out and mark correct later.

Paul