how to add bullet point in an Excel cell ?

[charlene]

how can I add bullet point in an Excel cell when preparing text ?

 

[Ron Coderre]

Try this:

Hold down the [alt] key...type 0149....release the [alt] key

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[JMB]

Hold down the Alt key and enter 0149 on the number keypad

or
=Char(149)

 

[charlene]

but when I hold down the [alt] key, I am not allowed to type any key .

Try this:

Hold down the [alt] key...type 0149....release the [alt] key

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

how can I add bullet point in an Excel cell when preparing text ?

 

[charlene]

I type =Char(149), then press [Enter] but the cell returns blank.

 

[Roger Govier]

Hi Charlene

Having pressed the Alt key, whilst holding it down, as you type 0149
from the numeric pad nothing seems to appear, but when you release the
Alt key having completed the key sequence, the bullet sign should then
appear.

The 0149 must be typed from the numeric pad, not the numbers from the
top row of the keyboard.
If you are using a Laptop computer, then you would need to use the
Function key + NumLk first, to invoke the embedded numeric keypad
utilising the letters MJU and 9 from the top row.

--
Regards

Roger Govier

but when I hold down the [alt] key, I am not allowed to type any key .

Try this:

Hold down the [alt] key...type 0149....release the [alt] key

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

how can I add bullet point in an Excel cell when preparing text ?

 

[Dave Peterson]

When I use that formula in a cell and that cell is using an Arial font, I see a
little square bullet shape.

I type =Char(149), then press [Enter] but the cell returns blank.

Hold down the Alt key and enter 0149 on the number keypad

or
=Char(149)

 

[JMB]

Works the same for me using Times New Roman. It looks better if you bold it.

That cells font color isn't white, is it?

When I use that formula in a cell and that cell is using an Arial font, I see a
little square bullet shape.

I type =Char(149), then press [Enter] but the cell returns blank.

Hold down the Alt key and enter 0149 on the number keypad

or
=Char(149)


:

how can I add bullet point in an Excel cell when preparing text ?