Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Gap both sides in XL table? (XP)

    Hello,

    As the screenshot shows, the indent can be used on the left side to put a small gap between the text and the cell.

    Is there a better way to do this?
    Also, the indent option only takes integers & sometime when you have a squashed table you need to specify decimal-value spaces.

    How can this be done?

    Bob.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Gap both sides in XL table? (XP)

    <hr>the indent can be used on the left side to put a small gap between the text and the cell. Is there a better way to do this?<hr>
    This is too general of a question. It depends on your needs/goals. Could you be more specific?

    <hr>The indent option only takes integers & sometime when you have a squashed table you need to specify decimal-value spaces. How can this be done?<hr>
    To line up numbers in a table, (eg) with a decimal point, the best way is with formatting (format - cells - Custom) and using the question mark (?) placeholder. The ? adds space for before and after decimal:

    Let's assume you have several numbers and they have different number of decimal places, and are different orders of magnitute. This could come if you want to have the same number of significant figures (eg, 4, based on the measurements)
    For example, If you want to align on the decimal point the following numbers:

    100.2
    10.34
    1.456

    Select them all and format - cells - custom"
    <pre>??0.???</pre>


    This tells excel to leave a placeholder (a space) for the hundreds, and tens, always put a value in the digits (I want to have 0.xx, never just .xx) and leave a space for the tenths, hundredths and thousandths place.

    Steve

Posting Permissions

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