word wrap issue

Is there a way to alter the word wrap feature so that it does not use the 
hyphen (-) to drop the text to the next line.  For example, the phrase "The 
cost is approx. $10MM which is a variance of -$5MM." should wrap as follows:
"The cost is approx. $10MM which is a variance of
-$5MM." 

but currently wraps as:
"The cost is approx. $10MM which is a variance of -
$5MM." 

I know I can manually correct with ALT Enter but I have several of these in 
mutliple tabs and wanted to see if there was a way (like through VBA) that 
could automatically change the wrap.

0
6/13/2006 3:10:03 PM
excel 39879 articles. 2 followers. Follow

0 Replies
392 Views

Similar Articles

[PageSpeed] 35

Reply:

Similar Artilces:

Row Not Found at the Subscriber
http://sanssql.blogspot.com/2010/05/row-not-found-at-subscriber-replication.html Regards, Sandesh Segu http://sanssql.blogspot.com/ ...

Reminder issues for Outlook 2010
When sending and receiving appointments the reciever is getting a default reminder for everything. We can shut off the defaults, uncheck the reminder before sending and still it defaults to 15 min reminder. With the number of appointments that we share, this has become a real pain. Please help with any advise and or suggestions. What version of Exchange server? There is a known issue with Exchange 2007. http://support.microsoft.com/default.aspx?scid=kb;en-us;973761 -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions ...

eConnect - MSMQ
I am able to send the xml data to MSMQ (server\private$\econnect_incoming75) que. The que is read by MBS eConnect service and then is deleted from the Que messages. The que apears in journal messages. The data never gets inserted into SOP tables. (SOP10100). The eConnect event viewer does not shows any errors. I am running MSMQ and eConnect on Windows 200 server. The eConnect and MSMQ runs on local system account. For MSMQ, If i log on This account, the MSMQ eConnect que disappeared. Anybody has any idea what must be the problem? Hi What account are you using for "This Acc...

Word always asks to save changes to the template
For my work we have made templates for different letters we have to send. Our application (VB6) calls those templates when we want to send a letter. Using the code we follow a few steps : - open word - open a new document using our template - save the document (.doc) on a server - sometimes print the document - sometimes immediately close the document (when we don't want users to modify the document afterwards) When they closed the document the users always get 2 questions : - save changes to template for the letter - save changes to normal.dot I already found a solution to avoid the q...

CAN'T OPEN PC-ORIGINATED WORD DOCS ON iMAC
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel sorry for the really basic new-guy question (i just got an iMac) but when i go to open some PC-originated .doc and all .docx files, i get an error that reads &quot;Word cannot open this document. The document might be in use or might not be a valid word document.&quot; !? anyone have any guidance? i've installed all the updates ... no luck. <br><br>thanks. > sorry for the really basic new-guy question (i just got an iMac) but when i go to open some PC-originated .doc and all .docx f...

Publisher font issue
I have an issue with Publisher 2000 and the calendar font size. The defaulted font size is 18. In each calendar date box, when I enter information is a smaller font (8 font), and save; close the program and then reopen; the 8 font text defaults to 18 font. I need the smaller font for information that needs to go into the calendar. I have tried a few tings through the help feature but nothing I do seems to work. Can someone help me with this or tell me how to fix this problem? Thanks Try this, put the calendar on the background (master page) Ctrl + m , use text boxes for your i...

Saving Word E-Mail as a Revision/Draft
Hi, I would like to be able to use the E-Mail feature in Word 2003 to save an email as a draft/revision for future use. I do not want to save the word doc as an attachment. Is this possible? Thanks, Josh Why don;t you just create the word doc, save it, and then email it when you're ready. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "JoshB" <JoshB@discussions.microsoft.com> wrote in message news:9710F08D-64E2-45B7-8115-BE8F0B116369@microsoft.com... > Hi, > I would like to be...

Exchange Migration Issue
Hello All, I have multiple copies of email in my user email accounts after migration. I used Exchange Migration Tool to Migrate email accounts from Exchange 2000 to Exchange 2003. Since we did not switch over to the new server right away , there were 2 days of emails still pending to be imported so I used the Migration tool again to migrate emails filtered based on date, but it seems that exchange migration has migrated all emails again, and now users have 2 to 3 copies of each email. Is there a way to remove the duplicate copies ? if so how can I go about doing that? Any pointer...

Entourage communication issue
My entourage quit communicating last week. Worked fine wednesday, thursday not. I can open entourage, but it won't send or retrieve mail. times out and gives a message that it's a server issue. My wife's works fine. tried installing the latest upgrade from microsoft, still no change. Both our macs have the same email configuration. tried the fixes given in the help section - snding myself an email, restarting entourage, etc, nothing. I'm not a computer genius, and need help. By the way, if i go into windstream via the internet, every thing's normal Thanks,Tj On 7/24...

store mounting issues
(this is not related to my other similar post today) My client's sbs machine was affected by sudden shutdown in a storm. Now when the server restarts we have to manually mount the stores. I will check to see if the database is dirty and it probably is, do I need to restore from backup? This seems toi be a time consuming operation, is the best way to proceed? I would start by looking in the Event Log. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "pepper" <pepper@discussions.microsoft.com> wrote in message news:28C8A34D-E...

Selection.AutoFilter Issue
I have the same code for 5 different reports. The only difference in code is the criteria filtered and removed. All reports filter and remove the desired data just fine except for one. The code is below and it is the same each reports with the exception of the worksheets it is deleting and Criteria1 for each sheet. NOTE: The BCP E&M code below filters correctly but not the others...and they are the same code! Any help would be greatly appreciated. Dim myLastRow As Long Dim myLastColumn As Long Dim myLastCell As String Dim myRange As String Dim Newbook As String Di...

Linking Word And Excel
I am trying to link several fields in Excel to a Word Doc. I'm linking the fields using Ctrl-Paste as Hyperlink. The linking works fine. However, when I try to save the files in different folders or move the files, all the links are lost. This makes it very hard to replicate the linking for my 6 analysts. Any help would be greatly appreciated. Brady -- **************************************************************************** Brady T. Finney Atlantic Management Company, Inc. Orchard Park - Suite A12 875 Greenland Road Portsmouth, NH 03801 603-436-8009 (Office) 617-413-4554 (Mobil...

How to quote cells when "IF" word is involved
On Sheet1, I have a data set (C1:C100) based on the input of cell A1. When A1 has various method choices,say,"method 1","method 2","method 3", each cell in the data set will have a new value accordingly. (=IF(A1="method 1",formula1,IF(A1="method 2",formula2,formula3)) I want to quote those three data sets on Sheet2. A lousy way is I could just duplicate Sheet1, set A1 to different value and quote data sets from different sheets. Is it possible to quote three data sets simultaneously from Sheet1? Thanks, Ming Perhaps use a 2 variable data t...

page numbers in Word 2007
Hello, I have a Microsoft Word 2007 document which has a title and table of contents on the first page and the various chapters on the following pages. I have used an automatic TOC and then clicked on the Insert tab and then Page Number -> Bottom of Page to insert page numbers. My problem is that I don't want the first page to be numbered so that the second page starts with the number 1. I have tried clicking Page Number -> Format Page Numbers... to set the first page number at zero but then when I delete the zero all page numbers are deleted by Word 2007 just as th...

Word Wrapping in Excel
I am having trouble with Word Wrapping in Excel. It does not adjust th row height properly. I have tried Format, Rows, AutoFit and it stil doesn't work. Help, pleas -- Mandy1 ----------------------------------------------------------------------- Mandy11's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1300 View this thread: http://www.excelforum.com/showthread.php?threadid=27632 Hi do you experience this with merged cells. If yes->nothing you can really do about this without using vBA -- Regards Frank Kabel Frankfurt, Germany Mandy11 wrote: > I...

Font Issue 12-01-09
> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3342466225_2506650 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: 8bit I upgraded my iMac to Snow Leopard and tried as best I could to follow the directions re deleting old and duplicate fonts for Office 2004 and 2008. That seemed to correct the gibberish I was getting in Entourage, but I am left with constant �error� messages asking me if Entourage (2008) can use a font on one of my several external...

Embedding a single workbook in a word doc
I prepare memos and I insert a bunch of tables out of a single excel file with a bunch of interlinked sheets. I typically insert them as pictures or linked pictures; however we often email the memo around for comments and and it gets complicated to have multiple versions and keep the links current. The other option is to insert the tables as embedded objects; however, if I do that, each table becomes a separate excel file, so I can=92t make changes to one and have it reflected in the tables throughout the document. Is there any way to create a single embedded workbook which I use several ti...

Access 2000... how to import a word document?
I am told Access will allow inport of a Word document by converting the document to Rich Text w/delimiter, then into Access. Does that not work with Access 2000? It depends what you mean by "import a Word document". If you have data in a table in a Word document, convert the table to text, paste the text into a new file, and save it as plain (not rich) text; then import the text file into Access. Alternatively, paste the table into Excel, save in Excel or CSV format, and import the resulting file into Access. Which of these works best depends on just what's in the data. ...

Word to edit e-mail messages
I am unable to select 'Use Microsoft word to edit e-mail messages' in the mail format options panel. The option is not for selction, it is greyed out. I am running Office 2000 with Outlook 2002. Any suggestions? Do you have Word installed? >-----Original Message----- >I am unable to select 'Use Microsoft word to edit e-mail >messages' in the mail format options panel. The option is >not for selction, it is greyed out. I am running Office >2000 with Outlook 2002. > >Any suggestions? >. > Hi Kev, coz you have to use Word 2002 to use it as...

Problems with Mail Merge from Word 2000 to Outlook 2000 in Win98
Hi there- I've been successful at trouble shooting my employees many mail merge problems, but this one is stumping me: Windows 98 Outlook 2000 Word 2000 Mail merge from a Word doc, no errors in the merge data, but the messages never show up in the Outlook outbox. Possible issues: computer also has Outlook Express 6 on it and Eudora. But shouldn't matter, becase neither of those have mail merge capabilities from Word. Any thoughts? Many thanks Jesse It sure could matter. Outlook must be your default mail program. -- Russ Valentine [MVP-Outlook] <jesse.littlewood@gmail.com>...

outlook meeting issue
Hi I am using outlook 2000. I invite people for a meeting and they accept then I get accetance reply form them. all of a sudden, I am getting any reply even though people accept and send me a reply. It used to work fine. If any one has this problem and know the way to work around. I appreciate for you help. Thanks ...

Create New Style in MS Word 2007
Hi I am trying to create a new style in MS Word 2007 that should go after "Heading 3". I am can't use Heading 4 since it is not numbered. So my document has levels 1 1.1 1.1.1 1.1.1.1 << This is the new style I am trying to create. But unfortunately I am not able to find a way to number it and use the "Continue Number from previous list". Also how to add levels to the style. Is there any way to copy Heading 3 and start from there? Thanks in advance. -- kuul13 ------------------------------------------------------------------------ k...

nonbreaking word
Can you keep Publisher 2007 from breaking a specific word? Turn off hyphenation in Options, edit tab. You can change the spacing in the font (format, character spacing). -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "lindalou" <lindalou@discussions.microsoft.com> wrote in message news:BE4F445E-9085-4DCA-AC36-6556C4F151DC@microsoft.com... > Can you keep Publisher 2007 from breaking a specific word? Does that mean that there will be no hyphenation in the entire document, or can you do it just for specific wor...

how do I set up the fax in word 2007
can anyone tell me how to set up the fax facility There is no fax facility in Word. If you have a fax modem installed and fax software, you should also have a fax 'printer' driver. Print to that. http://www.gmayor.com/fax_from_word.htm -- <>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><&...

Wrap text limits in Excel 2003 cell formatting
We have an Excel document which needs to support rather lengthy text entries. We formatted the cell to wrap the text, but at a certain point, it stops wrapping. In the Knowledge base, I've found basic information regarding formatting cells and it included the following statement. " Select Wrap Text to wrap the text in the selected cell. The number of wrapped lines depends on the width of the column and the length of the cell contents." So I guess my question is does anyone know how to control the number of wrapped lines OR is there a fixed limit to the text wrapping i...