Results 1 to 8 of 8

Format Cell: Align by Decimal

This is a discussion on Format Cell: Align by Decimal within the Excel Questions forums, part of the Question Forums category; I have numerous reports that are supposed to align numbers by the decimal place. Until now, I have been copying ...

  1. #1
    New Member
    Join Date
    Jun 2002
    Location
    Salomon Smith Barney
    Posts
    6

    Default

    I have numerous reports that are supposed to align numbers by the decimal place. Until now, I have been copying over to MS Word tables and using the simple 'Center on Decimal' tab-stop but I would prefer to stay in Excel for reporting.

    Any ideas on how I might create a custom number format to make a column line up by decimal?

    Thanks much

  2. #2
    MrExcel MVP, Moderator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default

    Just change the format of the cells to Accounting, and change the symbol to "none" if you don't need it.

    Hope this helps,
    Kristy

  3. #3
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,055

    Default

    You can also use the "Number" format, any number of decimal places, as long as it's the same number of places for the entire column.
    Barry-

    Photo Restoration/Enhancement

    http://www.smiledogproductions.com
    click below for detour


  4. #4
    New Member
    Join Date
    Jun 2002
    Posts
    11

    Default

    On 2002-06-25 06:39, Von Pookie wrote:
    Just change the format of the cells to Accounting, and change the symbol to "none" if you don't need it.

    Hope this helps,
    That doesn't work for me.
    What should the cell format look like?

  5. #5
    MrExcel MVP, Moderator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default

    There is no specifc format, really.

    Say you have the number 123.45 in cell A1, and 123456.78 in A2. Select those cells, go to Format|Cells and on the Number tab, choose Accounting from the list. Change the symbol and number of decimals if you need to, then click OK.

    This should line the numbers up at the decimal point, as well as adding commas if necessary. When I did it, it also automatically resized the column.
    Kristy

  6. #6
    New Member
    Join Date
    Jun 2002
    Posts
    11

    Default

    But that is what any number format does if you have a fixed number of decimal places.

    The original question was about having variable decimal places but with the decimal point centered.

  7. #7
    MrExcel MVP, Moderator Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686

    Default

    Ah. Well, if the original post had perhaps mentioned this factor, then that would have gotten on the right track.

    In this case, I can't help.
    Kristy

  8. #8
    New Member
    Join Date
    Jun 2002
    Posts
    11

    Default

    On 2002-06-25 07:42, Von Pookie wrote:
    Ah. Well, if the original post had perhaps mentioned this factor, then that would have gotten on the right track.

    In this case, I can't help.

    Sorry. You are right about the original post not mentioning it.
    I was looking at another post (http://www.mrexcel.com/board/viewtop...2447&forum=2&1) which wanted to center the decimal with varying decimal places.
    Too many open windows!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com