• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Custom formatting numbers

Hi,

Could you please provide custom formatting for
910,664 to appear as 911
-541,190 to appear as (541)
1,230,456 to appear as 1,230
-2,534,610 to appear as (2,534)
 

NARAYANK991

Excel Ninja
Hi ,

In formatting , a comma is used to divide by 1000 ; thus , a number such as 3537 , when formatted as #,.000 will display 3.537

For displaying negative numbers in parentheses , just include them in the format string as follows :

(#,.000)

Putting together both of them , a format string :

#,##0,;(#,##0,)

will display what you want.

By the way , the final value of -2,534,610 will be displayed as (2,535) due to rounding.

Narayan
 
Top