xl2003 let me use Gord's technique.

Can you change the number, then change the direction?

I'm not sure why you can't change this, but maybe you could use a macro:

Option Explicit
Sub ChangeIndent()
With Selection
.HorizontalAlignment = xlRight
.IndentLevel = 1
End With
End Sub

Select a group of cells, run the macro and see what happens???

Jack B wrote:

Gord,

That is the first thing I tried. However, when you
FormatCellsAlignmentHorizontalRight then Indent (enter a number), the
Right automatically changes to Left, and you can't get a Right Indent. At
least it won't do it for me.

Jack
-------------------------------------

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
FormatCellsAlignmentHorizontalRight Indent.

Set to 1

Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 16:46:57 -0400, "Jack B"
wrote:

Re Excel 97 ---

I would like to format a bunch of cells so that when I enter numbers they
will not be flush against the right side of the cell -- I want to have a
space between the numbers and the right side of the cells without having to
hit the spacebar after each number. How do you do that?

Jack


--

Dave Peterson