 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2004Leader dots
Is there any to put leader dots in fields (between the text and the end of the field; useful where gridlines are not shown)? Thanks. You could use a custom format: *.General The asterisk says to repeat the next character (I chose dot) as many times as to fill the cell. Then I used General, but you could use any format you wanted. > Is there any to put leader dots in fields (between the text and the end > of the field; useful where gridlines are not shown)? Thanks.  SignatureDave Peterson Thanks. I want, however, the leader dots to follow text and run over to the column where the numbers are. I can see that reversing the instruction to General*. will make the leader dots follow rather than precede, but this does not appear to work with text. Also, if possible, the leader dots should use the more conventional dot-space-dot-space format. Appreciate your help. > You could use a custom format: > [quoted text clipped - 5 lines] >>Is there any to put leader dots in fields (between the text and the end >>of the field; useful where gridlines are not shown)? Thanks. DR Maybe this format? "@*." Gord Dibben Excel MVP >Thanks. I want, however, the leader dots to follow text and run over to >the column where the numbers are. I can see that reversing the [quoted text clipped - 12 lines] >>>Is there any to put leader dots in fields (between the text and the end >>>of the field; useful where gridlines are not shown)? Thanks. Does this help? Custom format: ;;;@* After the asterick, enter a <Space>, THEN, hold down <Alt>, and enter 0149 Using the numbers from the num keypad, *not* the numbers under the function keys. SignatureHTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== Thanks. I want, however, the leader dots to follow text and run over to the column where the numbers are. I can see that reversing the instruction to General*. will make the leader dots follow rather than precede, but this does not appear to work with text. Also, if possible, the leader dots should use the more conventional dot-space-dot-space format. Appreciate your help. Dave Peterson wrote: > You could use a custom format: > [quoted text clipped - 7 lines] >>Is there any to put leader dots in fields (between the text and the end >>of the field; useful where gridlines are not shown)? Thanks. Sorry, Enter a <Space> *BEFORE* the asterisk ! SignatureRegards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- Does this help? Custom format: ;;;@* After the asterick, enter a <Space>, THEN, hold down <Alt>, and enter 0149 Using the numbers from the num keypad, *not* the numbers under the function keys. SignatureHTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== Thanks. I want, however, the leader dots to follow text and run over to the column where the numbers are. I can see that reversing the instruction to General*. will make the leader dots follow rather than precede, but this does not appear to work with text. Also, if possible, the leader dots should use the more conventional dot-space-dot-space format. Appreciate your help. Dave Peterson wrote: > You could use a custom format: > > *.General > > The asterisk says to repeat the next character (I chose dot) as many times as to > fill the cell. Then I used General, but you could use any format you wanted. >>Is there any to put leader dots in fields (between the text and the end >>of the field; useful where gridlines are not shown)? Thanks. Thanks all. Works fine. I should have messed with this app a long time ago. FYI either the group or my provider was down until now. Also this message might not position itself correctly -- I am using TBird and it's not doing well yet in handling strings. > Sorry, > Enter a <Space> *BEFORE* the asterisk ! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.