Hi Anauna,
Use this format (format, cells, custom) to fill remainder with periods
@*.
Use this format to fill beginning with periods (leader dots)
*.@
The format doesn't have to be text formats, the following would
provide asterisk protection on dollar amount.
**$#.###.00
http://www.mvps.org/dmcritchie/excel/formula.htm
Using Formatting to Change the Way Numbers, Dates, Times, and Text Appear in Microsoft Excel,
http://support.microsoft.com/default...ts/default.asp
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Anauna" wrote in message ...
Hello,
In Quattro I can place a backslash (\) followed by a character...say = and
the character will fill the cell regarless of column width.
Is there a process in Excel to achieve the similar outcome?
--
Thank-you and all suggestions are appreciated.