Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: decimal alignment of numbers with various decimals

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Belgium
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    --------------------------------------------------------------------------------
    I need to "decimal align" a lot of numbers , some of them with decimals of varying length, others without decimals. When the numbers have no decimals, i don't want to see a decimal separator. If i use the ? i only see the decimals i need to see but i can 't get rid of the decimal sign for the whole numbers. Can anyone help me???
    Thanks a lot!!!!

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    I can't imagine why you would need that but...

    I could not find a cell format that worked. You could try to simulate what you want by placing the whole numbers in one column, right justified, and place the decimal portion in the next column, left justified. The problem is that the spacing on each side of the decimal will probably not match. Therefore you could split it into three columns whole number, decimal ,and decimals, but that's ugly.

    You could also convert the numbers to text, use a constant width font. You should be able to make a suitable equation from the available math and text functions.

    Good luck,

    Brian

  3. #3
    Board Regular
    Join Date
    May 2002
    Location
    Ipswich, Suffolk, England
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use the text to columns with the delimiter set as "." if you then left align anything in the right hand columns (the decimal numbers) and right align the left hand column (Whole numbers) this will give you a printable version of what you are looking for

  4. #4
    New Member
    Join Date
    May 2002
    Location
    Belgium
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i don 't need this for a printout and the numbers should remain numbers so converting them to text won't do...
    it really should look like this:
    2
    100
    30,34
    111,3345

    i still hope someone will find a solution...

  5. #5
    New Member
    Join Date
    May 2002
    Location
    Belgium
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    my example in the foregoing message didn't work...i see al the spaces are lost so my firgures aren't aligned as they should.

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,049
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-05-06 04:11, Kristel wrote:
    --------------------------------------------------------------------------------
    I need to "decimal align" a lot of numbers , some of them with decimals of varying length, others without decimals. When the numbers have no decimals, i don't want to see a decimal separator. If i use the ? i only see the decimals i need to see but i can 't get rid of the decimal sign for the whole numbers. Can anyone help me???
    Thanks a lot!!!!
    Kristel,

    Did you try

    #,##0.??????_);(#,##0.??????);0.??????_);@

    which is a custom format?

    Aladin

  7. #7
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [/quote]

    Kristel,

    Did you try

    #,##0.??????_);(#,##0.??????);0.??????_);@

    which is a custom format?

    Aladin

    [/quote]

    Aladin
    I get a decimal after integers when using that format, e.g 2 becomes 2.

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,049
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-06-28 00:47, inarbeth wrote:

    Kristel,

    Did you try

    #,##0.??????_);(#,##0.??????);0.??????_);@

    which is a custom format?

    Aladin
    Aladin
    I get a decimal after integers when using that format, e.g 2 becomes 2.
    That's right. The following

    #,##0.0?????_);(#,##0.??????);0.0?????_);@

    would show 2 as 2.0

    Anything better on offer would be nice.

Some videos you may like

User Tag List

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
  •