Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Alignment (exel 97 & 2000)

    I fill in a column of a spread sheet with various values. (They are extreme temperatures) the results are of various significant figures. Is there a way in excel to align the values in a cell so when viewed in the column the values are aligned through the decimal point, the decimal point being the centre of the cell. I have the values centred at the moment but it just looks a bit untidy.
    cheers andrew macdonald

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Alignment (exel 97 & 2000)

    Andrew

    I would suggest that you leave the values right justified. This would then be the default behaviour of MS-Excel.

    If you really want to have them centred, then I guess you will need to pad the numbers with some leading zeros, and trailing zeros. This you can do via formatting the number with enough places depending on your data. For example if you would use the following: "0000000.00" this will pad the numbers up to 7 zeros.

    Also I would suggest that you use a uni-spaced font such as Courier.

    HTH

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Oct 2001
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alignment (exel 97 & 2000)

    thanks for the quick reply wassim, i will look at the work book & see.

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Alignment (exel 97 & 2000)

    I agree with Wassim, but another idea to try, depending on your format, is to pad more spaces on the right using custom formatting. For example, modify:

    #,##0
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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