Try custom formatting the range with: @*.
[Format Cells Custom In "Type:" box: @*. ]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Tom" wrote:
I hope some one can help me.
I need to make a table and want to make sure that each cell with text is
automatically filled by dots/periods/points. The length of the text is
different in each cell, butthe width of the cell itself is the same.
As an example:
Net Sales...........................................
Depreciation...................................... .
Please let me know if you can help!