formating text cells

[Guest]

I need to format a text cell using bullets similiar to Word's bullets and
numbering? Any idea on how to do that? Can Excell automatically generate
the bullet?

 

[Guest]

Excel doesn't support this the way Word does. I'd use Word, if at all possible.
One alternative in Excel:
If you put the text of the bullet point in B1, put this in A1 to generate a
"bullet":
=IF(B1<>"",CHAR(149),"")
Copy this down as far as needed.

You will likely want to use Align Right on Column A as well. Not a bad idea
to adjust the width of Column A, either.

tj

 

[Frank Kabel]

Hi
no
Excel just is a spreadsheet and not a word processor ;-)

 

[Gord Dibben]

Cathlyn

Format>Cells>Number>Custom

Hold down ALT key and type 0149(from numpad) then a space then @

Returns • Cathlyn or • Gord

Whatever text is typed in gets a bullet.

Gord Dibben Excel MVP