Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Straight Text Displays as a series of #######
Hi - I have a problem that seems somewhat random, but is very tanacious when
it occurs. I have entered the following text into a cell: "5=yes, and affects all other screens without any re-key required. 4=Yes, but some manual re-keying of data required. 3= Yes, but only affects current screen. All other screens must be manually re-keyed. 2=Only the Regional Manager can reschedule a move-in 1=NO, Must call support to reverse a move-in." Minus the quotation marks. The cell is set to type "Text" and Wrap is turned on. However the text displays as a long series of ###################### In another nearby cell I have the following text inserted under identical conditions: "4=Yes, When move-in is committed, billing cycle is automatically completed including invoice generation. 3=Yes, but invoice not automatically generated. 2=Yes, but further manual date entry required. 1=No." This text displays exactly as it should? I am running Office 2003 under Windows XP. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Straight Text Displays as a series of #######
Excel has a problem with Text formatted cells when number of characters is
between 255 and 1024. Re-format to General and your #####'s will go away. Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 15:49:01 -0700, RjS, CISSP, CISA wrote: Hi - I have a problem that seems somewhat random, but is very tanacious when it occurs. I have entered the following text into a cell: "5=yes, and affects all other screens without any re-key required. 4=Yes, but some manual re-keying of data required. 3= Yes, but only affects current screen. All other screens must be manually re-keyed. 2=Only the Regional Manager can reschedule a move-in 1=NO, Must call support to reverse a move-in." Minus the quotation marks. The cell is set to type "Text" and Wrap is turned on. However the text displays as a long series of ###################### In another nearby cell I have the following text inserted under identical conditions: "4=Yes, When move-in is committed, billing cycle is automatically completed including invoice generation. 3=Yes, but invoice not automatically generated. 2=Yes, but further manual date entry required. 1=No." This text displays exactly as it should? I am running Office 2003 under Windows XP. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move values text in graphs all series at once. Excel | Charts and Charting in Excel | |||
Bubbles with multiple series | Charts and Charting in Excel | |||
Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
Text displays as ### in a cell. | Excel Worksheet Functions | |||
Copy formula so destination displays formula as text | Excel Discussion (Misc queries) |