Negative number formatting

[VickyJones]

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.

[Dave Peterson]

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.
>
> --
> 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

[VickyJones]

Thanks, that's brilliant!