A VBA method ..

http://vbaexpress.com/kb/getarticle.php?kb_id=549

I believe that was first created by Aaron Blood.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"AndiB" wrote in
message ...

As another alternative, you might also try holding down the ALT key,
press a number on your keypad (Num Lock ON, MUST use keypad to type the
number), release, and see what symbol appears. The symbol that appears
varies depending on the font you choose. Example: Using Arial font,
ALT + 7 results in a square bullet; ALT + 9 results in a diamond.

You can also press ALT and type multiple numbers on the keypad (Num
Lock ON, MUST use keypad to type the number), then release, until you
see a symbol you like. Example: Using Arial font, ALT +14 results in
a right-pointing triangle.

Be sure to write down what font you are using and the numbers you used
so you can use that symbol again later.

The down side of this is you still don't get the nice hanging indent
like you do in Word (so text lines up under each other and bullet it
out to the left), but if you've got to do the work in Excel, this is
one way to do it, and pasting a bulleted list from Word doesn't hold
the indent either.


--
AndiB


------------------------------------------------------------------------
AndiB's Profile:
http://www.excelforum.com/member.php...fo&userid=7771
View this thread: http://www.excelforum.com/showthread...hreadid=358304