Try the following custom format:-

#,###,

This will display 1,523,754.25 as 1,524

Add how you want negative numbers to display at the end by sepearting
the codes with a semi colon (ie in brackets minus sign etc)


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=385200