ExcelBanter - Bullets and numbers

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

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

- - Bullets and numbers (https://www.excelbanter.com/excel-discussion-misc-queries/131837-bullets-numbers.html)

OnWire

Bullets and numbers

How can i use bullets and numbers within a cell?

Gary''s Student

Bullets and numbers

1. separate your text or list into distinct lines by placing a hard return
(ALT-ENTER) where appropriate

2. precede each line with a period and a single space

3. format the period with a large font to simulate a bullet
--
Gary's Student
gsnu200707

"OnWire" wrote:

How can i use bullets and numbers within a cell?

Gord Dibben

Bullets and numbers

Alt + 0149(on the numpad) then the number.

Note: this will format the cell as text.

Alternative if you want the number to stay as a number...........

FormatCellsNumberCustom Alt + 0149 #,##0

Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 05:05:30 -0800, OnWire
wrote:

How can i use bullets and numbers within a cell?

All times are GMT +1. The time now is 11:55 AM.