Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Marc
 
Posts: n/a
Default 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   Report Post  
PokerZan
 
Posts: n/a
Default


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   Report Post  
Marc
 
Posts: n/a
Default

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   Report Post  
gls858
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Form Problem ??? mully New Users to Excel 5 July 2nd 08 11:53 AM
Is there a way to convert a EXCEL form into a WORD form? Carole O Excel Discussion (Misc queries) 1 April 27th 05 10:13 PM
Data Form Deletions CyberTaz Excel Discussion (Misc queries) 1 April 26th 05 01:25 PM
Excel 97 form - please help! Leanne Excel Discussion (Misc queries) 2 March 16th 05 12:08 PM
Trying to delete form border, and it deletes all borders PeterM Excel Discussion (Misc queries) 11 January 3rd 05 04:36 PM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"