Thanks, Sandy. I cannot say I have noticed that the size of the indentation
changes with font, since I tend to use one font consistently. What triggered
my question was that, in one particular spreadsheet I had been using for some
time, the indentation suddenly tripled in width (more or less), without any
change to the number of 'characters' it was supposed to indent (still only
one.)

As an alternative, I have now learned that I can use a custom format to
indent as much or as little as I like (an underscore followed by a character
will indent by the width of the second character; include the pair to the
right or left of the numeric or text format, depending on which side you want
the indentation to appear; repeat the pair, including the underscore, to
indent by more than one character width), but I think that might end up being
more trouble than it's worth....

Regards,
Hugh John

"Sandy Mann" wrote:

Like you, in XL97 I find that the indent is inconsistant inasmuchas it
apears to vary with the font size. With Arial 8 point it is fully two
characters indent but with 72 point it is only a fraction of a character.
The question mark help dialog box says:

"Indents cell contents from the left side of the cell.
Each increment in the Indent box is equivalent to the
width of one character."

I assume therefore that it is one character of a particular font, possibly
true type, as a particular point size and it does not alter with changing
font/points

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"hjc" wrote in message
...

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