View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default repeating periods?

Select the cell(s)

Click Format Cells Custom
In the "Type:" box, enter: @*.
(Include the single period "." just after the "@*")

If you put it as: @*-
it'll repeat the dash character: "-"
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"austin" wrote in message
...
how do you put repeating periods after your text without typing each

period?