text line shows as all ####

noviceuser · May 16th, 2002, 03:03 PM

I have merged about 12 or so cells at the bottom of a sheet of financial figures and calculations. The merged cell extends over the enter lenght of my sheet and I need to use it to enter text that will appear as a footnote to my financial figures. I have selected "wrap text" for the merged cell. However, every time I get to a certain point of typing in text in the cell, the cell changes from my text to all #######. This happens at the same point every time I type in the text. It happens in the middle of the second line of wrapped text. What am I doing wrong?

xl · May 16th, 2002, 03:07 PM

Make your column bigger.

noviceuser · May 16th, 2002, 03:10 PM

The column is the size I need for it to be to fit my report. I need for the text to wrap within the cell. The text currently wraps onto a second line but everytime the text gets larger than about half way through the second line, the line changes to all ######.

xl · May 16th, 2002, 03:21 PM

Then you are SOL. Too bad for you.

brettvba · May 16th, 2002, 03:22 PM

Drag the row line down for text wrapping

inarbeth · May 16th, 2002, 03:36 PM

Dear noviceuser
Hope this is not too basic for you but if you go to Format, Cells, Alignment tab and Wrap text you should have no problems. I have created a macro attached to a toolbar button to do this as it is a regular requirement. I don't know why Microsoft don't make it a standard button.

noviceuser · May 16th, 2002, 04:29 PM

I've tried all of this. Wrap text is checked and the text will wrap once, onto a second line. I've also expanded the row. Once I reach that magic length of text and the text changes to #####, I can even expand the row by several inches but the text stays #####.

bergy · May 16th, 2002, 04:44 PM

Quote:

On 2002-05-16 15:29, noviceuser wrote:
I've tried all of this. Wrap text is checked and the text will wrap once, onto a second line. I've also expanded the row. Once I reach that magic length of text and the text changes to #####, I can even expand the row by several inches but the text stays #####.

I just replicated your problem, sort of. Are your cells formatted as text or general. When the cell is formatted as general it works fine. When I changed the cell to Text I got "#######". Good Luck

Magoo · May 16th, 2002, 04:45 PM

Hi Novice

have you tried highlighting the whole worksheet and then double clicking on one of the column separators (ie, place your cursor between columns A & B until the cursor changes into a funny thing with arrows going left and right? Follw the same procedure for the rows as well.

anno · May 16th, 2002, 04:53 PM

what happens if you hard enter a line break (alt+enter)? also, you could try reducing the font size and use arial narrow.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 03:03 PM	#1
noviceuser New Member Join Date: May 2002 Posts: 12	I have merged about 12 or so cells at the bottom of a sheet of financial figures and calculations. The merged cell extends over the enter lenght of my sheet and I need to use it to enter text that will appear as a footnote to my financial figures. I have selected "wrap text" for the merged cell. However, every time I get to a certain point of typing in text in the cell, the cell changes from my text to all #######. This happens at the same point every time I type in the text. It happens in the middle of the second line of wrapped text. What am I doing wrong?

May 16th, 2002, 03:07 PM	#2
xl New Member Join Date: May 2002 Posts: 10	Make your column bigger.

May 16th, 2002, 03:10 PM	#3
noviceuser New Member Join Date: May 2002 Posts: 12	The column is the size I need for it to be to fit my report. I need for the text to wrap within the cell. The text currently wraps onto a second line but everytime the text gets larger than about half way through the second line, the line changes to all ######.

May 16th, 2002, 03:21 PM	#4
xl New Member Join Date: May 2002 Posts: 10	Then you are SOL. Too bad for you.

May 16th, 2002, 03:22 PM	#5
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Drag the row line down for text wrapping

May 16th, 2002, 03:36 PM	#6
inarbeth Board Regular Join Date: Apr 2002 Location: Wivenhoe, England Posts: 877	Dear noviceuser Hope this is not too basic for you but if you go to Format, Cells, Alignment tab and Wrap text you should have no problems. I have created a macro attached to a toolbar button to do this as it is a regular requirement. I don't know why Microsoft don't make it a standard button.

May 16th, 2002, 04:29 PM	#7
noviceuser New Member Join Date: May 2002 Posts: 12	I've tried all of this. Wrap text is checked and the text will wrap once, onto a second line. I've also expanded the row. Once I reach that magic length of text and the text changes to #####, I can even expand the row by several inches but the text stays #####.

May 16th, 2002, 04:45 PM	#9
Magoo New Member Join Date: May 2002 Posts: 28	Hi Novice have you tried highlighting the whole worksheet and then double clicking on one of the column separators (ie, place your cursor between columns A & B until the cursor changes into a funny thing with arrows going left and right? Follw the same procedure for the rows as well.

May 16th, 2002, 04:53 PM	#10
anno Board Regular Join Date: Feb 2002 Posts: 202	what happens if you hard enter a line break (alt+enter)? also, you could try reducing the font size and use arial narrow.