Hello all,

(XL & AC 2003)

I copied data from an AC query, pasted it into a blank XL sheet. I set all
of the values to this number format:

_(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
(the standard Accounting format, I think)

Now correct me if I'm wrong, but isn't this number format supposed to take
into account the parens and space positive numbers so the digits & decimal
places will line up? In other words, "0.00" should be spaced out from the
right edge of the cell the width of one closing paren, thus the zeroes &
decimal point in "0.00" should line up with the zeros & decimal point in
"(0.00)".

After applying this format, the positive numbers are not spaced out from the
right edge of the cell.

Has pasting data from AC somehow messed up the formats/alignment/some other
setting?

Thanks for any help anyone can provide,

Conan Kelly