Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I'm having an unusual problem with changes in formats in a cell
This is the text that is there now: "Remote head end - (This line item is
also shown in the Audio quotes) - television is not in the same location as the equipment - five (RG6QUAD) and one (CAT5E) with one wall plate at television and head end with five RCA inserts and one RJ45." When I add "Telephone, Network and Cable" in place of the "Audio" - between the parenthesis I end up with a line of # across the cell. This normally means that I need to either enlarge the cell or make the text size smaller but I've tried that to no avail. Any suggestions? Marc |
#2
|
|||
|
|||
I can't tell you why it is doing that... It worked fine for me in Excel 2003. Do you have the text fomated to "wrap"? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=388856 |
#3
|
|||
|
|||
Yes - It's done this kind of arbitrary weirdness before!!!! I went back and
deleted "with one wall plate at television and head end with five RCA inserts and one RJ45." from the cell and the ##### went away. The cells are merged and I doubled the cell size and the song remains the same. Marc "PokerZan" wrote in message ... I can't tell you why it is doing that... It worked fine for me in Excel 2003. Do you have the text fomated to "wrap"? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=388856 |
#4
|
|||
|
|||
Marc wrote:
Yes - It's done this kind of arbitrary weirdness before!!!! I went back and deleted "with one wall plate at television and head end with five RCA inserts and one RJ45." from the cell and the ##### went away. The cells are merged and I doubled the cell size and the song remains the same. Marc "PokerZan" wrote in message ... I can't tell you why it is doing that... It worked fine for me in Excel 2003. Do you have the text fomated to "wrap"? PZan -- PokerZan ------------------------------------------------------------------------ PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480 View this thread: http://www.excelforum.com/showthread...hreadid=388856 Is it possible you're reaching the 256 character limit for a cell? gls858 |
#5
|
|||
|
|||
Change the format of the cell from Text to General.
Marc wrote: This is the text that is there now: "Remote head end - (This line item is also shown in the Audio quotes) - television is not in the same location as the equipment - five (RG6QUAD) and one (CAT5E) with one wall plate at television and head end with five RCA inserts and one RJ45." When I add "Telephone, Network and Cable" in place of the "Audio" - between the parenthesis I end up with a line of # across the cell. This normally means that I need to either enlarge the cell or make the text size smaller but I've tried that to no avail. Any suggestions? Marc -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Problem ??? | New Users to Excel | |||
Is there a way to convert a EXCEL form into a WORD form? | Excel Discussion (Misc queries) | |||
Data Form Deletions | Excel Discussion (Misc queries) | |||
Excel 97 form - please help! | Excel Discussion (Misc queries) | |||
Trying to delete form border, and it deletes all borders | Excel Discussion (Misc queries) |