in our Office (Word) 2007 application, WTS 2008x64, the following happens
(for some - not all- users):
A text is written and formatted normally and without any problems.
The document shall be printed. After the printjob is executed, the chracters
of the text lines are compressed to only a few millimeters in width. The
font height remains normal. Nothing is legible. This now ocurs on the
printed doc as well as on the screen. After the doc is saved and opened in a
different session, everything is OK and works well...
What can I do?
As always, every help and ...Numbers and text
I have a link table from an Excel sheet. The first column is for account
numbers but some are numbers only and I get the "#num!" error. The only way I
can get rid of the error is to retype the number in Excel.
I have tried formatting the cells in Excel as "text" but it doesn't work.
Is there a work around?
...Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...Text Effects Scrolling or Blinking text
How do apply the scroll or blinking feature to text that you want to
emphasize in a word document. Prior to MS2007 there was a feature on the
fonts tab that allowed a user to apply the following features to text
"marching ants, blinking text, scrolling marquee, etc. I cannot find the any
of these features anywhere in Word 2007. "HELP"
There is no direct access to them, but they are still available by macro
I posted the following macro recently, for use in Word 2007
Dim sAnimation As String
If Len(Selection.Range) = 0 Then
MsgBox "...Word 2007: word count wrong?
I have an issue with some .doc files when opening in Word 2007. In some
cases the word count in the status bar is different of the word count of the
"Word Count"- window (CTRL+SHIFT+G) or the word count in Word 2003
Example file: http://go.microsoft.com/fwlink/?LinkId=79595
Word 2007 (status bar) show 61019 words
Word 2007 (Word count window) show 61010 words
Word 2003 also show 61010 words
This issue I have not with all documents, but only with some files and it
seems that I have this problem only with .doc files but not with .docx files.
(installed ve...What is 'Align Text to Base Line Guide'?
Trying to make sure all lines have the same amount of space between them I
selected paragraph from the format menu and under the line adjustments there
is a box 'align text to base line guides' Ok I did that, now there are lines
at the margines of my newsletter. What are these? Also selecting this pushed
my text down from the top edge of the text box. What is this?
The baseline guide measurements are in the Arrange, Layout Guides, Baseline tab.
There is help in the Help menu.
"Go_Girl3647" <GoGirl3647@discussions.microsoft.com...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Count # of cells b/w cells ...
I have the following data in a column: 7 0 0 0 7 0 0 0 0 0 7 0 0 7 0
0 0 0 0 0 7 etc.
The number of zero's between the 7's is random. I want a formula tha
would count the number of zeros between the 7's.
AriBari's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2504
View this thread: http://www.excelforum.com/showthread.php?threadid=38806
Assume A5:A20 is the data, try this:
B5 = A5+B4 (copy formula down)
Now make a table with 2 column...Ordering by number and text
I use a report to print out checklists that in the detail section have item
number to delineate each checklist item. The item numbers as an example are
1-1, 1-2, 1-2a, 1-2b, or 2-1, 2-2, 2-3, 2-3a, 2-3b and so on. The report is
grouped by checklist section and the grouping works perfectly but when the
report is printed the item numbers are ordered in this order 1-1, 1-10, 1-11,
1-2, 1-3, 1-3a, 1-3b, 1-4, 1-5, 1-6, 1-7, 1-9.
Obviously I want the the order to be in proper numerical sequence where 1-10
comes after 1-9. but even replacing the '-' with a decimal point doesn't
...How do text capture tools work?
Here are two examples of this technology.
Sounds like they will have to involve OCR, which works fine for standard fonts but
probably won't work with fancy fonts. Key here is to test them try a static control with
a TextOut and change the fonts and see what happens.
On Wed, 31 Oct 2007 15:02:04 -0500, "Peter Olcott" <NoSpam@SeeScreen.com> wrote:
>Here are two examples of this technology.
> http://www.deskp...count if a match occurs
I have two rows - say Row 1 and Row 2.
In the first row I have a answer key.
In the second row I have answers from a student.
I would like to write a formula where it counts how many answers student got write.
Here is a example:
Row 0: Q1 Q2 Q3 Q4 Q5 Q6
Row 1: 1 4 2 3 4 1
Row 2: 3 4 1 3 4 1
So student marked 4 questions correctly: Q2, Q4, Q5 and Q6.
Hence, the formula should return 4.
I know one way to do it but I am sure there is more efficient way to do it.
The way I know: Use if statement to compare two corresponding entries and output 1 if...Spiral text
Does anyone know how to create spiral text?
In a draw program for sure. You probably can get close in Publisher, but it will
not look as good as a draw program can do.
Serif has a free program you can try. DrawPlus
Mary Sauer MSFT MVP
"jaykay" <firstname.lastname@example.org> wrote in message
> Does anyone know how to create spiral text?
I've downloaded the program, but can't figur...Email Text Dissappears when Save
When we save email messages (as a draft) the text dissappears, even when th I
use my administrator account. Anybody have any idea what that is happening.
...obtaining data in text form from a table
I like to be able to obtain the dates in a text format from the table
Test6 4-Feb,5-Feb, 9-Feb
Do I need to do this by macros and if so, any help would be appreciated.
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb
Vlookup should do what you want, as in:
Adjust the ranges t...Count Age Grouping
I have an access 2k database in which I need to count groups of
records of individuals by that age groups such as
14- 20 no of individuals
21-30 no of individuals
31-40 no of individuals
41-50 no of individuals
51-60 no of individuals
61-70 no of individuals
71-80 no of individuals
80+ no of individuals
I have both DOB and Age fields in the table
I have tried several queries but with no luck and ideas
On 19 Mar 2007 16:51:49 -0700, "Nemesis_uk" <email@example.com> wrote:
>I have an access 2k ...Count the text in a column
I would like to count the text in a column then for it to add a figure in
another cell if it meets the text criteria
Do you mean count the characters?
as an array formula (committed with Ctrl-Shift-Enter)
(remove nothere from the email address if mailing direct)
"Peter Curtis" <PeterCurtis@discussions.microsoft.com> wrote in message
> I would like to count the text in a column then for it to add a figure in
> another cell if it meets the t...Converting number to text
Is it possible to convert, say 1234 to one thousand two hundred and thirty
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> Is it possible to convert, say 1234 to one thousand two hundred and thirty
...Setting Text in a ComboBox
Hi, Does anybody know why I cannot set the text in the
edit control of a CBS_DROPDOWN style CombBox control
I was able to change the text in the edit control part of
the ComboBox manually.
I don't know why can't you? Post some code. You should be able to
"Vincent Yu" <firstname.lastname@example.org> wrote in message
> Hi, Does anybody know why I cannot set the text in the
> edit control of a CBS_DROPDOWN style ...anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of
the box I have a happy face. I'd like the happy faces to be anchored to
their corners so when I enlarge or shorten the box, the faces move along with
the text box.
Why not create a rectangle, insert the happy faces, group. The problem as I see
it would be if you resize, the happy faces could be distorted if you widen or
shrink the group. You would always have to re-size proportionally.
"Helen" <Helen@discussions.microsoft.com> wrote in message
i was asked to do a simple project
1-want do a text ticker can be scroll left to right and right to left
4-has a background image
please where can i start and how to do it
BitBlt background to offscreen bitmap
TextOut to the bitmap with appropriate offset and clipping region
BitBlt offscreen bitmap to client area of screen
Use a subclassed CStatic
On 18 Aug 2006 20:59:22 -0700, "Prafulla T" <email@example.com> wrote:
>i was asked to do a simple project
>1-want do a text tic...Counting the number of times more than 1 variable occurs
I need to determine how many Separations were processed by a particular
A | B
1 MIKE | SEPARATION
2 MIKE | LEAVE
3 SARA | SEPARATION
4 JOE | SEPARATION
5 JAMIE | LEAVE
6 MIKE | LEAVE
7 JOE | LEAVE
8 SARA | SEPARATION
The only way I can think of is the COUNTIF Funtion
This does not work though. The results return 0 with no errors when
the answer should be 1.
does anyone else know of a wa...text box email publication
I am a publisher novice. I am trying to develop an e-mail newletter. The
templates in publisher have a text box under each article with what appears
to be a hyperlink with "more details". I assume this will enable the reader
of the email to expand the text box and see the full details of the article.
I like this feature as it means that readers only get to see the title and
abstract and then can select the articles they want to read in full.
Unfortunately I can not work out how to use this function and as usual help
is no help.
Tim no such feature in Publisher.
"kiwi ti...Counting number of words in a sentence and highlighting or commenting
I found some old code, from Helmut of Bavaria I believe, that is
supposed to find long sentences in a document:
Dim rDcm As Range ' the documents main story range
Dim oWrd As Object ' a word
Dim oSnt As Object ' a sentence
Dim oPrg As Paragraph ' a paragraph
Dim lWrd As Long ' a counter for words
Dim lSnt As Long ' a counter for sentences
Dim lPrg As Long ' a counter for paragraphs
Set rDcm = ActiveDocument.Range
For Each oPrg In rDcm.Paragraphs
lPrg = lPrg + 1
lSnt = 0
For Each oSnt I...