View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default How do I align numbers in different cells when some are in bracke.

Custom format is:
" "#" ";"["#"]";" "#" ";@

The extra spaces will help align the numbers.

--
Best Regards,

Luke M
"Doogie" wrote in message
...
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