Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tricky Formatting Problem (2002)

    Hey, I just got a question about cell formatting in Excel.
    Is it possible to format a currency cell so that the dollar sign ($) is left aligned and the number (eg. 4.50) is right aligned?
    I was able to do it using a custom format, however doing it that way, the number of spaces is fixed and the column width increases with more digits in the number area. Any suggestions would be great, thanks,

    -naut

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tricky Formatting Problem (2002)

    From Excel 97 Help:
    To repeat the next character in the format to fill the column width, include an asterisk (*) in the number format. For example, type 0*- to include enough dashes after a number to fill the cell.

    Try formatting as $* #.##. That's an asterisk followed by a space.

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Tricky Formatting Problem (2002)

    Try formatting the cells as Accounting, this puts the $ sign to the left of the cell and numbers to the right.
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •