| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling a cell with "-"
I want a cell to contain all "-" (hyphens) no matter how wide the column is.
So if I make it wider or narrower, there will be a line of hyphens. Thanks for any help on this. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling a cell with "-"
Type
- Into a cell. You'll have to either preformat the cell as text or start with a leading apostrophe: '- Then Format|cells|Alignment tab|Horizontal Text Alignment|choose Fill (xl2003 menus) dhstein wrote: I want a cell to contain all "-" (hyphens) no matter how wide the column is. So if I make it wider or narrower, there will be a line of hyphens. Thanks for any help on this. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling a cell with "-"
=REPT("-",100)
"dhstein" wrote: I want a cell to contain all "-" (hyphens) no matter how wide the column is. So if I make it wider or narrower, there will be a line of hyphens. Thanks for any help on this. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filling a cell with "-"
Thanks to all for the responses.
David "Dave Peterson" wrote: Type - Into a cell. You'll have to either preformat the cell as text or start with a leading apostrophe: '- Then Format|cells|Alignment tab|Horizontal Text Alignment|choose Fill (xl2003 menus) dhstein wrote: I want a cell to contain all "-" (hyphens) no matter how wide the column is. So if I make it wider or narrower, there will be a line of hyphens. Thanks for any help on this. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Filling cells with absolute columns but "nth" rows | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Linear Mode
