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


0
Marc
7/20/2005 6:06:10 PM
excel.newusers 15348 articles. 2 followers. Follow

4 Replies
296 Views

Similar Articles

[PageSpeed] 0

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?action=getinfo&userid=23480
View this thread: http://www.excelforum.com/showthread.php?threadid=388856

0
7/20/2005 10:47:45 PM
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" <PokerZan.1shqif_1121900777.9578@excelforum-nospam.com> wrote in
message news:PokerZan.1shqif_1121900777.9578@excelforum-nospam.com...
>
> 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?action=getinfo&userid=23480
> View this thread: http://www.excelforum.com/showthread.php?threadid=388856
>


0
Marc
7/21/2005 12:42:04 AM
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" <PokerZan.1shqif_1121900777.9578@excelforum-nospam.com> wrote in
> message news:PokerZan.1shqif_1121900777.9578@excelforum-nospam.com...
> 
>>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?action=getinfo&userid=23480
> 
>>View this thread: http://www.excelforum.com/showthread.php?threadid=388856
>>
> 
> 
> 
Is it possible you're reaching the 256 character limit for a cell?

gls858
0
gls858 (460)
7/21/2005 4:07:39 PM
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
0
petersod (12004)
7/21/2005 4:22:25 PM
Reply:

Similar Artilces:

Making cell change colour
Hi all I want to make a cell change colour 'on click'. Is there any way that this is possible? Help would be appreciated, Many thank darren --- Message posted from http://www.ExcelForum.com/ Hi this would require VBA / using an event procedure like Selection_change. Do you want to go this way? -- Regards Frank Kabel Frankfurt, Germany > Hi all > > I want to make a cell change colour 'on click'. > > Is there any way that this is possible? > > Help would be appreciated, > > Many thank > > darren > > > --- > Message posted f...

Read receipt problems #2
Hi I'm using Outlook 2003 with 3 seperate email accounts, one of these accounts being my business account. How do I set up Outlook so that when using my business email address Outlook asks for a read receipt but not when using my personal email address? I have managed to set Outlook up to ask for a receipt ok but it asks for a receipt no matter which account i use. Thanks Simon Simon <si@com> wrote: > I'm using Outlook 2003 with 3 seperate email accounts, one of these > accounts being my business account. How do I set up Outlook so that > when using my business email...

Wierd CRM Problem
I am running CRM 3.0 SBE on SBS 2003 Premium. I have 17 CRM CAL's and 10 Server CAL's. I have 3 names users setup in CRM. Everything worked perfect when I was the only one logging in doing the customizations. I gave another person access to the system for testing purposes. Since then I lose access intermittently. I access through IE 7 and the server comes back as cannot find server. If I access the crm server via IP (192.168.1.XXX:5555), it prompts me for the login. I enter the information and when the first window closes the second window never comes up. If I then go to http:/...

Pasting a cells format problem
If I cut and special paste a cells format from a previous spreadsheet to a new spreadsheet I loose the ability to have the "Format Cells..." menu popup. either by right clicking on the cell and selecting "Format Cell .." or from the tool menu "Format\Cell..." The worksheet is not protected and there is no conditional formatting for the cell. How can I regain the ability to format this cell? Help. ...

%s in Accounting Format
I am using Excel 2007. I want to have a column that lists percentages - but to still be able to use the accounting single underline correctly. When I manipulate the accounting format to _(*#,##0.00%_) the underlining is not correct. If I use the accounting format I cannot get "%" signs. Thanks. Does this work? _(* 0.00%_);_(* (0.00%) -- Regards, Peo Sjoblom "jadeB" <jbschipper@gmail.com> wrote in message news:a9dfe12b-3c2f-4302-ba49-2c2dd39240c2@33g2000yqm.googlegroups.com... >I am using Excel 2007. > > I want to have a column that lists percen...

SMTP Problem
I am having a problem sending email out through my school's SMTP server. The error message is this: Your message did not reach some or all of the intended recipients. Subject: Test chapman out Sent: 9/15/2004 8:07 PM The following recipient(s) could not be reached: 'tim@stairwell.net' on 9/15/2004 8:07 PM 504 <timk>: Helo command rejected: need fully-qualified hostname My machine name is TIMK. Apparently, when outlooks sends the HELO command, it just uses the machine name and not a FQDN. Is there a way to force outlook to do this? How? Thanks! Tim No, you can'...

How to change date from US to UK format
Hi all, I have a large-ish spreadsheet (4000 entries) with a date of birt column. For some reason when this file was ported from SPSS into Excel before being sent to me, the dates of birth got a bit screwed up. ABout a third of them are in the format I want. UK format wit day-month-year. The rest are in US format with the month first. At th moment I'm having to just go through them and type or copy hem into new column. Its essential I have the whole column in UK format. Is there any formulas that can do this for me to save me typing it al out?!! Any help would be MUCH appreciated!! -- ...

Outlook 2002--How do I change account which email account is active?
I have a problem with a Outlook 2002 that makes me think the active account is corrupt. Each time I try to log onto ISP to get email, Outlook prompts me for the password. I have set the password through Windows software and when I log on thru Outlook, I keep checking the box to "remember password" but it doesn't. Now I'm getting connection errors that are not consistent and if I ignore them, I can still log on. This all makes me think maybe the account I'm using has become corrupt. How can I copy my User Files and then create a new account so I can delete the present acco...

Changing from Balance Forward customer to Open Item
Recently one of our affiliates imported their customers from their old accounting system. Unfortunately, the balance type flag was set to balance forward rather than open item. This was not discovered until significant activity had been keyed so they don't want to re-load and re-do several weeks' work. Is there any way to change a customer, with posted activity, to open item? Thanks Steve In the RM_Customer_MSTR table: RM00101 Balance Type: Integer. Field values: 0. Open Item 1. Balance Forward In SBM, this field is always set to a value of 1. This field is...

Complicated Formula Problem #3
Thanks Mark...I've sent you the file -- Llobi I am a Technology Specialist and District WebMaster for a schoo district in Texas ----------------------------------------------------------------------- Llobid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=777 View this thread: http://www.excelforum.com/showthread.php?threadid=27647 ...

why does currency format change to number format?
every time I format a column in the currency format and save, when I go back to that column, the formatting has changed to number format. How can I get this format to stay? Are you actually closing and reopening your file? If you are, how are you saving your workbook--as a .xls ("Microsoft Office Excel Workbook (*.xls)"? It kind of sounds like you're saving as a .csv (comma separated values) file. This type of file is plain text and won't preserve the formatting when you reopen it. Cassie wrote: > > every time I format a column in the currency format and save...

cell format update problem
say, c1, c2 is formatted as text. and a1,a2,b1, b2 are formatted as general. a1=1,a2=2, b1=1, b2 =2 and I entered c1 =a1+b1, c1 shows =a1+a2 as it is, not 3. I drag the corner of c1 and copy c1 to c2, c2 is a2+b2, So I have to F2 and enter all the cells, c1, c2. Is there a way other than "F2" and "Enter"? *Don't* format C1 to Text. Leave it General, or format to Number. -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "...

Fill blank cells
How can I automatically fill blank cells with placeholders? Select your range. Edit|goto|special Blanks Type your placeholder value and hit ctrl-enter. Debra Dalgleish explains a variation of this (with pictures!) at: http://www.contextures.com/xlDataEntry02.html jenny wrote: > > How can I automatically fill blank cells with placeholders? -- Dave Peterson Thanks, it worked great. "Dave Peterson" wrote: > Select your range. > Edit|goto|special > Blanks > > Type your placeholder value and hit ctrl-enter. > > Debra Dalgleish explains a variation o...

Problems with Partnersource/Customersource
Trying to download the new FRx service pack and manager does not seem to respond. I am having no difficulty downloading using the manager off MSDN or MCT sites. Anyone else experiencing this? ...

auto color blank cells ,best solution
i would like to automatically color all blank cells unfilled which can vary on each sheet at close of workbook,any suggestions .The total number of blank cells will be no more than 100 -- BD3 -- BD3 Maybe you're looking for something like this. It works for cells A1:J4 on Sheet 1, but you can change that as required: For rwIndex = 1 To 4 For colIndex = 1 To 10 With Worksheets("Sheet1").Cells(rwIndex, colIndex) If .Value = "" Then Worksheets("Sheet1").Cells(rwIndex, colIndex).Select With Selection...

MS money 2003 password problem
I saw threads that indicated that lots of folks have had problems w/passwords while using money software... I just re-loaded 2003, and it's asking for a password when we have never used a password before when we created the file w/2003 money. And - like so many others, it won't accept the password that is for our hotmail... what's up w/that? In microsoft.public.money, rowdog wrote: >I saw threads that indicated that lots of folks have had problems w/passwords >while using money software... I just re-loaded 2003, and it's asking for a >password when we have ...

Subtotal Problem
I have imported data from a golf software program listing three rounds of golf for individuals. I want to subtotal their scores based upon a team within the tournament. When I try the subtotal command Excel separates the team members but returns "0" for the subtotal. I was told that Excel does not recognize the content of the cells and I must multiply their value by "1" and do a special paste command . . . I forgot how to do that. Also, is this a problem with the golf software, data transfer, or something else? Thanks, Tom I don't know about golf software, but w...

Formatting long numbers accurately
I am working with credit card #s. As soon as I take out (Using Replace) the dashes, the last digit becomes a zero! I've tried everything, it's urgent. example: 1234-5476-7894-1236 to 1234547678941236 Format as text -- Regards, Peo Sjoblom "EMR" <anonymous@discussions.microsoft.com> wrote in message news:04ca01c3a736$e6cc09f0$a101280a@phx.gbl... > I am working with credit card #s. As soon as I take out > (Using Replace) the dashes, the last digit becomes a > zero! I've tried everything, it's urgent. > example: 1234-5476-7894-1236 to 123454...

Problem with blank messages
Hi there, About 2-3 weeks ago I received my first blank message. i.e. a message with no sender, no subject and no body. I carefully deleted it without much thought. Over the next two weeks I received more an more, starting with a trickle of one-or-two a day and escaleting to betwen 30 and 50 blank messages each day. I'm worried that they are carrying viruses, trojans, bots or the like. I've run a full virus check with my F-Prot, and tested with Adaware, and SpyBot. No suspicious files have been revealed. I'm working on a running Outlook 2003 (11.8010.6568) SP2. My Toshiba Sa...

brainteaser: change a value by 90 (but answer must lie between 0-180 )
Please see below ( I want to do step 3 - change a value by 90 degrees) but the answer has to be between 0 and 180 e=2Eg. 45 becomes 90 e=2Eg. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer is 5 ***************************************************************************= ********* from http://www.usaeyes.org/faq/subjects/script.htm Minus Cylinder or Plus Cylinder Spectacle prescriptions can be written in two value sets, minus cylinder or plus cylinder, which are mutually exclusive of each other but provide the same information. As a rule, ophthalmologists write script...

Photo email problem in non-beta version
The last time I successfully tested the photo email option in the current WLM (not the beta) was June 10th. A question about it recently came up in the Windows 7 Forums that points out it may now be broken. So I tested it again and indeed verified it is broken. At least for the both of us: http://www.sevenforums.com/browsers-mail/99858-sending-pictures.html . So it must have broken sometime after June 10th. I updated to the latest non-beta version (14.0.8117.0416) on June 20th so that may be the problem. Can anyone with the latest non-beta version let us know if you have the same...

CPropertySheet Problem
Hi, I have created a NON-MODULE CPropertySheet in a form. And I have added several CPropertyPage to the sheet. There's a runtime error where I call SetWindowText of CProertyPage which is not the first one. I was told that the page is not a window (hWnd = NULL). Only the first page can use SetWindowText. How can I change the tab name of the pages at rumtime? BTW, I can set the captions of the pages in design time. And I was failed to get the tab pointer by calling GetTabCtrl. Thanks. Done. before propertysheet.create page1.m_psp.dwFlags |= PSP_USETITLE; page1.m_psp.pszTitle = &quo...

Sound problems
Config: IE8, XP Pro service pack 3, separate audio card. Audio is working fine with several applications but NOT with IE (although audio on web pages is enabled). It has been working earlier though. Should I uninstall IE and reinstall it or is there another remedy? -- TS Hi Ossian, Do you have a link to a web page where this is occurring? You could have pressed the mute button on the Flash video you are trying to watch and the site is retaining your preferences as you view other 'videos'. Here is a link to a test page that will help you diagnose sound issues with ...

Autofill problem
Hi, any help gratefully recieved. If I write a formula then fill down I get the same answer in every cell. Typing in manually the excat same formula gives me the correct answer. The formulae are exactly the same whether filled or put in manually. Is this a known glitch? Thanks Will ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Will, You've left this to guesswork. Tell us the original formula, and what the fill actually produces (formula, not result). Look...

Automatically copy cells from two week day sheets based from today
I have a schedule workbook with the days of the week listed as sheets, Mon->Sun. I want to have another sheet that displays half of today’s schedule and half of tomorrow’s schedule but it will change day to day depending on today. I need it to automatically copy the info so I am not constantly cutting and pasting or making seven new pages. ...