Custom formatting numbers

[Ecel Dumbo]

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)

 

[AlanSidman]

Assume data is in column A
In B1 =ROUND(A1,-3)/1000

and copy down

crossposted at:https://www.excelforum.com/excel-general/1187404-custom-formating-numbers.html

 

[NARAYANK991]

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

 

[Ecel Dumbo]

Thank you Narayan. Very clear explanation
Thank you Alan for your solution