| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell: right align with indent
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell: right align with indent
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 On Fri, 1 Feb 2008 06:06:01 -0800, wb198 wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell: right align with indent
Excell 2000,
thanks "Gord Dibben" wrote: 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 On Fri, 1 Feb 2008 06:06:01 -0800, wb198 wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell: right align with indent
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 On Sat, 2 Feb 2008 07:26:03 -0800, wb198 wrote: Excell 2000, thanks "Gord Dibben" wrote: 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 On Fri, 1 Feb 2008 06:06:01 -0800, wb198 wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell: right align with indent
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! "Gord Dibben" wrote: 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 On Sat, 2 Feb 2008 07:26:03 -0800, wb198 wrote: Excell 2000, thanks "Gord Dibben" wrote: 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 On Fri, 1 Feb 2008 06:06:01 -0800, wb198 wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell: right align with indent
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 On Thu, 14 Feb 2008 12:58:01 -0800, wb198 wrote: 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! "Gord Dibben" wrote: 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 On Sat, 2 Feb 2008 07:26:03 -0800, wb198 wrote: Excell 2000, thanks "Gord Dibben" wrote: 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 On Fri, 1 Feb 2008 06:06:01 -0800, wb198 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format CellsAlignmentIndent | Excel Discussion (Misc queries) | |||
| INDENT TEXT IN A CELL | Excel Discussion (Misc queries) | |||
| Format and Align Columns | New Users to Excel | |||
| How can I remove an indent within a cell? | Excel Discussion (Misc queries) | |||
| Format numbers so they align | Excel Discussion (Misc queries) | |||
Linear Mode
