View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 40
Default How to offset cell value from thick border lines?

Dallman Ross wrote:
spake thusly:
What is the best way to offset cell values (text and numbers) from the
cell border lines?


Have you tried Format Cells - Alignment - Indent ?


Thanks for your response.

Yes I had. But after seeing your response, I tried again, and I
discovered that I had misinterpreted the use of the Indent buttons on
the toolbar with respect to the right margin. It had not occurred to
me that I press "-|" to move right(!).

Okay, right-indent would align everything nicely on the right. But it
offsets things more than I would prefer. I would prefer to move things
to the right "just a skosh", similar to the custom format that I use
(or the one you suggest).

Is there any way to change the amount of movement that Indent causes?
I did not see anything under Tools Options, but I might have missed
it.

Third, for right-adjusted numbers, I select a
Custom number format of the form #,##0 " ".

[....]
Try custom: #,##0_)


How is that different than or why is that preferred over what I did --
which I should have written as #,##0" " (no extra space)?

In any case, I believe that works only for numeric values, not for
text. The right-index solution would work for both.

BTW, is there any Help text that explains the Custom format syntax? I
did not find anything myself when I searched for "custom format".
However, I did not look at Online Content. (I usually disable that
feature.)

Thanks again.