Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accounting Space (97 and on)

    I've just resolved a most aggravating user problem by telephone - spurious space characters appearing at the left of a cell.
    User entered plain string text in cells.
    Some cells appear correctly left-aligned; other cells have an apparent space between the left boundary of the cell and the leftmost character of the string.
    The problem cells had been formatted in Accounting format.
    Presumably the space is MSoft's way of telling us there was always the possibility of dropping a currency symbol in there, had MSoft found any numeric characters worth formatting.
    But it is Accounting format, not currency.
    The dialogue box says that Accounting format aligns decimal points and currency symbols, if any.
    Oddly enough, Accounting format WITH a chosen currency symbol still seems to introduce the space.
    I can't think of a good reason for having that space there at all.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Accounting Space (97 and on)

    <hr>I can't think of a good reason for having that space there at all.<hr>
    Just a matter of taste, I guess, since I really like having that space and format cells to get it (it also shows up in the 'comma' formats). It separates text in titles and labels from the cell border when laying out a table, as well as providing a little more space between numeric values and any text in the cell to the right.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accounting Space (97 and on)

    > I really like having that space and format cells to get it
    Good point.
    The example below shows that I can engineer two spaces, or more, should I choose, but that would mean designing custom formats all over the place (or using Styles, not a bad idea ...)
    I probably should have said "I can't think of a good reason for designing it that way, but it's too late now.
    I agree that extra white spaces makes things more readable.

Posting Permissions

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