How do I correct ##### error in a cell formated as text?
 

The cell is formatted as text and I have entered only text and 4 bullets. Why
does it show #############/.

Resizing it doesn't solve it.

How do I correct ##### error in a cell formated as text?
 

What exactly is the text? hope it doesnt start with =

"Sonia" wrote:

The cell is formatted as text and I have entered only text and 4 bullets. Why
does it show #############/.

Resizing it doesn't solve it.

How do I correct ##### error in a cell formated as text?
 

The text is something like thids
"Here are my reasons
- one reason 7 No M3(superscript)
- two reasons
- three reasons"
I have also tried changing the bullet to
–ª one reason 7 No M3(superscript)
–ª two reasons
–ª three reasons
Thanks
"Atishoo" wrote:

What exactly is the text? hope it doesnt start with =

"Sonia" wrote:

The cell is formatted as text and I have entered only text and 4 bullets. Why
does it show #############/.

Resizing it doesn't solve it.

How do I correct ##### error in a cell formated as text?
 

Do all lines appear ###### or just those with "-" at the beginning? Try
adding an apostrophe (') before "-" and make sure the cell is in "General"
number format.

Sonia wrote:
The text is something like thids
"Here are my reasons
- one reason 7 No M3(superscript)
- two reasons
- three reasons"
I have also tried changing the bullet to
–ª one reason 7 No M3(superscript)
–ª two reasons
–ª three reasons
Thanks

What exactly is the text? hope it doesnt start with =

The cell is formatted as text and I have entered only text and 4 bullets. Why
does it show #############/.

Resizing it doesn't solve it.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1

How do I correct ##### error in a cell formated as text?
 

Ok thanks, formatting it to 'general' seems to solve the problem.

"pogiman via OfficeKB.com" wrote:

Do all lines appear ###### or just those with "-" at the beginning? Try
adding an apostrophe (') before "-" and make sure the cell is in "General"
number format.

Sonia wrote:
The text is something like thids
"Here are my reasons
- one reason 7 No M3(superscript)
- two reasons
- three reasons"
I have also tried changing the bullet to
–ª one reason 7 No M3(superscript)
–ª two reasons
–ª three reasons
Thanks

What exactly is the text? hope it doesnt start with =

The cell is formatted as text and I have entered only text and 4 bullets. Why
does it show #############/.

Resizing it doesn't solve it.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1