Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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 "Cathyinliberty" wrote: 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? |
#3
![]() |
|||
|
|||
![]()
Hi
no :-) Excel just is a spreadsheet and not a word processor ;-) -- Regards Frank Kabel Frankfurt, Germany "Cathyinliberty" schrieb im Newsbeitrag ... 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? |
#4
![]() |
|||
|
|||
![]()
Cathlyn
FormatCellsNumberCustom 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 On Sun, 28 Nov 2004 10:19:03 -0800, "Cathyinliberty" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I rotate a text box | Charts and Charting in Excel | |||
How can I asign a number value to a text line in Excel? | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel | |||
background formatting across multiple cells | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |