ExcelBanter - repeating periods?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - repeating periods? (https://www.excelbanter.com/excel-discussion-misc-queries/59117-repeating-periods.html)

austin

repeating periods?

how do you put repeating periods after your text without typing each period?

Max

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?

All times are GMT +1. The time now is 03:32 AM.