Prev: In Excel, when i key in 02352 and press enter, the zero goes off
Next: Delete rows data moving
From: Doogie on 17 May 2010 09:20
I trying to show both positive and negative numbers in a lsit. The negative
numbers are in brackets however this puts the numbers out of alignment with
each other. Is there away to ensure the numbers are aligned and the closing
bracket sitting outside the line of numbers.

Thanks
From: Luke M on 17 May 2010 09:58
Custom format is:
" "#" ";"["#"]";" "#" ";@

The extra spaces will help align the numbers.

--
Best Regards,

Luke M
"Doogie" <Doogie(a)discussions.microsoft.com> wrote in message
news:80D99DE5-CE44-4C33-B033-8339757E5D23(a)microsoft.com...
>I trying to show both positive and negative numbers in a lsit. The negative
> numbers are in brackets however this puts the numbers out of alignment
> with
> each other. Is there away to ensure the numbers are aligned and the
> closing
> bracket sitting outside the line of numbers.
>
> Thanks


 | 
Pages: 1
Prev: In Excel, when i key in 02352 and press enter, the zero goes off
Next: Delete rows data moving