Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
In my excel spreadsheet there is are merged cells that I input text into each
month. Some seem to work fine, however others display a single line of ########### instead of my actual text. Why does this happen, and how can I fix it? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
Probably the cell is formatted as Text.
Re-format to General. Excel has problems with Text-formatted cells when character count is 255 to 1024 BTW.....unless the merged cells are just for appearance, I would dump them. They will cause you no end of problems with sorting, copying, pasting, autofitting and a host of others I can't remember right now. Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 12:05:05 -0800, ExcelRon wrote: In my excel spreadsheet there is are merged cells that I input text into each month. Some seem to work fine, however others display a single line of ########### instead of my actual text. Why does this happen, and how can I fix it? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
Generally this means the cell is too narrow to display the stored entry
But merged cells have their own problems best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ExcelRon" wrote in message ... In my excel spreadsheet there is are merged cells that I input text into each month. Some seem to work fine, however others display a single line of ########### instead of my actual text. Why does this happen, and how can I fix it? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
That happens for either of two reasons: (1) the column is not wide enough to
display the data, or (2) the cell is formatted for date and/or time and the cell contains a negative value. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "ExcelRon" wrote in message ... In my excel spreadsheet there is are merged cells that I input text into each month. Some seem to work fine, however others display a single line of ########### instead of my actual text. Why does this happen, and how can I fix it? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
It worked! I re-formated to General and now my text is displayed. Thanks for
the tip. I agree about merged cells, I try to avoid them whenever possible, but there's no way around this one. Thanks again for the tip. Ron "Gord Dibben" wrote: Probably the cell is formatted as Text. Re-format to General. Excel has problems with Text-formatted cells when character count is 255 to 1024 BTW.....unless the merged cells are just for appearance, I would dump them. They will cause you no end of problems with sorting, copying, pasting, autofitting and a host of others I can't remember right now. Gord Dibben MS Excel MVP On Wed, 28 Feb 2007 12:05:05 -0800, ExcelRon wrote: In my excel spreadsheet there is are merged cells that I input text into each month. Some seem to work fine, however others display a single line of ########### instead of my actual text. Why does this happen, and how can I fix it? Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel; shows a line of # instead of my text in a merged cell.
Chip
See my post for possible third reason when mucho text in a Text-formatted cell. Gord On Wed, 28 Feb 2007 14:46:23 -0600, "Chip Pearson" wrote: That happens for either of two reasons: (1) the column is not wide enough to display the data, or (2) the cell is formatted for date and/or time and the cell contains a negative value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi line merged cell - adapting to different size input - possible? | Excel Discussion (Misc queries) | |||
Excel will not show all text entered in a Cell merged from 9 rows | Excel Discussion (Misc queries) | |||
Inserting line breaks into merged text cells. | Excel Discussion (Misc queries) | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
Excel merged cell - can it automatically expand as text is typed? | New Users to Excel |