Bullets and numbers

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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...........

Format>Cells>Number>Custom Alt + 0149 #,##0


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you paste a list of bulleted text from a word doc. into exc 2
Bulleted or numbered list inside cell? 1
Bullet points 7
PowerPoint PowerPoint Bullet Indents Stoppe Working w/ Last Update on Mac 0
remove bullet from sheet in Excel, imported from Powerpoint 2
How to insert bullets between the words in footer 2
Text not display in a cell. 1
How to use bullets & numbering within a cell ? 6

Back
Top