Negative number formatting
 

Hi everyone, does anyone know how to do this? I hve a column of figures,
some positive and some negative. I want to format them so taht the
negative numbers are expressed in (brackets) and also so that the
column itself is decimal aligned, so even if I don't use decimal places
the brackets "stick out". I know Word does this in tables, but I can't
seem to make Excel do it. Help! Thanks, Vicky. :confused:


--
VickyJones
------------------------------------------------------------------------
VickyJones's Profile: http://www.excelforum.com/member.php...o&userid=24484
View this thread: http://www.excelforum.com/showthread...hreadid=380834

How about a custom format of:

#,##0.00_);(#,##0.00);0.00_);@

It uses two decimal spots and whole numbers will be shown like 7.00.

VickyJones wrote:

Hi everyone, does anyone know how to do this? I hve a column of figures,
some positive and some negative. I want to format them so taht the
negative numbers are expressed in (brackets) and also so that the
column itself is decimal aligned, so even if I don't use decimal places
the brackets "stick out". I know Word does this in tables, but I can't
seem to make Excel do it. Help! Thanks, Vicky. :confused:

--
VickyJones
------------------------------------------------------------------------
VickyJones's Profile: http://www.excelforum.com/member.php...o&userid=24484
View this thread: http://www.excelforum.com/showthread...hreadid=380834

--

Dave Peterson

Thanks, that's brilliant!


--
VickyJones
------------------------------------------------------------------------
VickyJones's Profile: http://www.excelforum.com/member.php...o&userid=24484
View this thread: http://www.excelforum.com/showthread...hreadid=380834