Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
Hello. Here are two ideas you can experiment with. Suppose that Boston is
in A1, and 100000 is in cell B1. For A1, make a custom format as "@ *." The @ represents the text in the cell (Boston), and the "*" repeats the next character (period) the width of the cell. Or, perhaps leave Boston alone, and customize B1 with "*. $#,###.00" This would put leading periods in front of the number. HTH. :) -- Dana DeLouis Win XP & Office 2003 "wstock3" wrote in message ... If you look at financial data you will see that there is often a leader (dotted underline), between a field name or catagory and the data that it is referencing. An example: Region Revenue Boston..........$100,000.00 I am trying to determine how to do this in excel. I do not want to underline the entire cell. I want the leader to start at the end of the word an go to the end of the cell. Any help is appreciated - Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I insert a clip art picture into a text box in word 2003 | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Retriveing a text from one sheet and insert to another | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |