format cell: right align with indent

  • Thread starter Thread starter wb198
  • Start date Start date
W

wb198

Hi,
How do you format a cell so that it is right-aligned but indented (from the
right) so the data is not right up against the side of the cell?
You can do this with left align (indent it from the left), but in my version
of excel you can't do it from the right.
Any ideas? I've looked for "cell padding", for example, but no luck.
Thanks
 
Which version of Excel are you running?

I believe Right Indent has been around for quite a while but I only have 2003
running at present.


Gord Dibben MS Excel MVP
 
Excell 2000,
thanks

Gord Dibben said:
Which version of Excel are you running?

I believe Right Indent has been around for quite a while but I only have 2003
running at present.


Gord Dibben MS Excel MVP
Click to expand...
 
Thanks for the feedback

I didn't know Excel 2000 did not have a right indent.

You could run a macro on currently entered text or use event code to add a space
after the text in each cell as you entered it.

Post back if interested in either method........or both.


Gord
 
thing is I am most interested in doing this for numbers, not text, so they
line up properly (right align) but not right up against the side of the
cells.
i thing the easiest will be to upgrade to Excel 2003 then!
 
Try the accounting format which gives you a right side indent and lines up on
decimal points.

You could change the accounting style to remove the $ signs if you so choose.


Gord
 
Back
Top