Number Formating

[suryaa30]

Hi I am using below expression using Num fucntion. For large values the values are shown below. How do i resolve this?

=Num(Expression,'$###,###')

[rahulpawarb · Accepted solution]

Use below given Number format:

=Num(Expression, '$###,##0')

Regards!

Rahul Pawar

[suryaa30]

Thanks Rahul, what is the significance of the change and the break down of num function?

[rahulpawarb]

Hello Surya,

0 : Digit that has to be shown (can be used for padding 0's)

# : Digit is showed only if it's necessary

e.g.

Num(123, '0000') will show 0123

Num(123, '####') will show 123

Regards!

Rahul Pawar