Exactly! In Excel 2007 I'm looking for a way to customize the indent
function, in a text box, no less, so that I get a small separation from the
border. Does the fact that this question has not been answered lead you to
believe that there is no way it can be done? The boss requires the text box,
or I'd figure out some other way to make it look right. Well, if anyone
finds out anything, I'll be watching. Thanks for asking the right question,
even if there isn't an answer!


"hjc" wrote:


When indenting text or numbers using the 'Indent' box on the 'Alignment' tab
in the 'Format Cells' dialog, is there a way to control the increment by
which the text is indented? Right now, even when I set the indent value to
1, the text is indented considerably more than if I simply add a space at the
end of the text.

Worse, the increment does not always seem to be consistent from spreadsheet
to spreadsheet or over time. I have one spreadsheet where the indentation is
approximately one-third of the cell width in a column with the width set to
12, yet the indent value is still set to 1! The format used to be o.k. in
this spreadsheet, so I'm not sure what has changed...I did not change the
indentation setting.

Any help that can be provided will be much appreciated -- thanks!

HJC