Formatting Text in a Forwarded Email Message
Odd problem in Outlook on one of our pc's. We are using Outlook 2002 SP3.
When attempting to forward a message, I sometimes change a few of the words
in the body of the message. I place the cursor within the word I wish to
change. As soon as I type one letter, any letter, the letter shows up two
font sizes bigger (from 12 to 14), and with a space on each side of the
What seems to make this more puzzling is that when I attempt the same task
on our other pc, everything functions as it should; no change in font size
and no extra spaces.
Any help in eli...How do I expand the amount of text I can put in a cell?
I am entering text into a cell & can see it in the formula bar up top, but
it's giving me the #### in the cell that states it's too big. How can I get
it to show my text?
Put your cursor between the column you want to expand, and the column to the
right. When you see a four sided arrow, click and drag it to the right. You
may need to also Format, Cell, Alignment and click on Wrap Text.
Hope this helps,
> I am entering text into a cell & can see it in the formula bar up top, but
> it's giving me the #### in the cell...Legend Line Spacing
Is there a way in VB to force a legend to display in single line spacing
rather than what appears to be double line spacing?
I am using the following code to control the display of the legend. Is
there a property I can add that will control the line spacing?
Selection.AutoScaleFont = False
.Name = "Arial"
.FontStyle = "normal"
.Size = 9
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Under....qfx file in excel
my bank for some reason will only allow me to download my statement in a qfx
file (quicken) but i dont have any quicken programs i use excel to manage my
finances how can i open this file up???
If the bank does not have .text (.txt) or comma separated variables (.csv),
which would probably be listed as spreadsheet format, then
I would complain to the bank.
Meanwhile you could copy and paste from your checking activity
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: ....mdi Files
Operating System: Mac OS X 10.5 (Leopard)
I have some .mdi files (generated at work with some lab software). They seem to open okay on my work PC. Is there any way that I can get Office 2008 and a MAC to recognize / open these?
No, .mdi is a Windows-only format exclusive to the Microsoft Document
Imaging program... Even other Windows apps can't read or create them.
If you can get them into a Windows box open them in MDI & then Save As TIFF
to get a format that can be opened by graphics apps or inserted into other
documents as a picture. TIFF files are ...Comparing text strings
I have two columns populated with names and I need to compare them for
duplicates. Some duplicate names may contain middle initial or middle names
and some don't. So they may not be EXACT. Please give me suggestions on
formulas or funcions that would help me accomplish this task.
On Fri, 27 Nov 2009 11:12:01 -0800, Comparing columns with text <Comparing
columns with firstname.lastname@example.org> wrote:
>I have two columns populated with names and I need to compare them for
>duplicates. Some duplicate names may contain middle initial or middle names
...Unable to start up my Excel files
One of my users have this odd issue with his Excel 2003. He's unable to
start the files directly but instead he must start a blank excel sheet then
open his files from there. Is there a solution to this issue?
Dell 170L P4 800mghz 1gbram
Windows XP Pro SP2
Office 2003 SP2
Could the problem be that he cannot open files by double-clicking on them
from Windows Explorer, but must open Excel (which will launch a blank sheet)
and then open them directly from there using File / Open...
If so then tell him to try Tools / Options / General / untick 'Ignore Othe...File password override
I'm trying to restore a backup file. Money is asking for a
file password. I enter the password that is appropriate for
the Passport account used to lock the file, but Money will
not accept that.
I wonder if this file has a seperate file password and if
so, I have no memory of what it may have been. Is there
some way to reset it? Is there some other way in to this file?
Though I sympathize with your problem, I certainly hope there's no back
door. If there is, I'm going back to paper records. I shudder to think
that a hacker could conceivably get an older backup file an...How to use the countif() function to count items in a table
I have a table contains multple columns of info as shown
in the below
AcctID ProjectName PMName Phase Status
EIG Project 1 Wellie Initiation New
MLI Project 2 John Develop Active
EIG Project 11 Wellie Qualify Active
EIG Project UUU John Design InActive
MLI Project XX Carol Deployment Completed
MLI Project YYY Carol Design Active
I'd like to use the countif() function to complete the
following metric such that I know how many projects for
each status for each AcctID.
EIG ...Change a text box to a combo box
I have created several forms in my database.
I realized that I should have made them combo boxes instead of text boxes.
Is there any easy way for me to change them into the format I need?
Thank you in advance for your help.
Right-click on the text box and select changeTo from the menu.
"forest8" <email@example.com> wrote in message
news:FD867B89-38CC-4F20-A9AE-C177444DA9DA@microsoft.com...the > Hi there
> I have created several forms in my database.
> I realized that I should have made them combo ...opening .dat Accounts Receivable file in Great Plains for DOS
We are trying to retrieve some information from a posted accounts receivable
report... We think its in a .dat file but have no way of opening... This
anyone know if this is possible...
Any help or suggestions would be greatly appreciated!
Can you be a little more specific? What version of GP, what report, what
"Carmine" <Carmine@discussions.microsoft.com> wrote in message
We are trying to retrieve some information from a posted accounts ...Pivot Table Text Only, No calculations
:confused: I have a spreadsheet of data, text only. An address list.
want to look at the table by city. Is there a way to do this withou
calculation? For example, I want to have a city has the page field an
look at all the addresses, including columns, within that city.
rmm30's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=835
View this thread: http://www.excelforum.com/showthread.php?threadid=26902
A pivot table is a good tool for summarizing data, but won't help...Creating a duplicate lead
Am I right in assuming there is no way to create a duplicate lead from an
existing one? I'm asking because I have multiple people within the same
company - would like to add a second lead without retyping all the address
info, etc., that would be exactly the same.
check out the free c360 Clone utility:
It'll do what you need.
> Am I right in assuming there is no way to create a duplicate lead from an
> existing one? I'm asking because I have multiple people within the same
> company - would ...csv-file problems with different regions
I have imported an American csv-file into a German Excel XP. The American
$-values are separated by a "." while the German currency values are
separated by a ",".
So now my spreadsheet reads a value of $ 18.01 as 18. January. All values
above 18.12 are ok.
How can I avoid this problem? Or, can I change the values tediously one cell
after the other? I have not found a way yet as even when I try to format a
cell user defined it automatically changes to the format used in the German
Temporarily change the regional settings on your computer to the same f...File set up query.
Can i set up an excel file to open automatically on pc start up?
The easiest is to use the Startup folder available in the Start Menu. To
access it go to Start - Programs - Startup. You can delete or add tasks here
according to your needs. They will start after Windows logon.
When you start Excel, all the files that are located in the XLStart folder
are automatically opened. Additionally, if you specified an alternative
startup folder for Excel, every file in that folder is also automatically
opened. To specify an alternative startup folder, in Microsoft Excel 2002 or
Microsof...Sorting file list by date/time...
does anybody have an idea how to program a sorting function given a
directory with files, which should red to an array which is sorted by date
and time, but contains only the filenames.
Is there a MFC function or a shell function of the OS which could ease the
job instead of doing it manually?
On Mon, 16 Apr 2007 16:39:50 +0200, "Diana Bulthaupt"
>does anybody have an idea how to program a sorting function given a
>directory with files, which should red to an array which is sorted by date
>an...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
I have an MFC application, where I'm interested in displaying some
text for the user in the client area. To do this, I create a device
context, and use the .TextOut method to display CStrings.
The problem begins when the window is resized, or when a menu that
hides the text pops - once the menu is closed, or after the window has
been resized, the text (or parts of it) are being erased.
How can this be solved? I read that when the window is resized,
OnPaint is called, and thus I tried displaying the text from there -
hoping to re-display it "after" it has been erased. The...Linking text to style for auto update
I want to auto update figure/table number in text to that in Figure/Table
Use Insert > Cross Reference to put the numbers into the text; they
don't update every time the numbering changes, but only when you tell
them to (Ctrl-A, F9) or when you print or switch to Print Preview.
On Dec 18, 4:05=A0pm, Taurus <Tau...@discussions.microsoft.com> wrote:
> I want to auto update figure/table number in text to that in Figure/Table
> style numbers
...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
I am working from a very large word document, approximately 1000 pages
long. Each page has one 'article' on it.
I am currently doing something manually, which I would love to do
using a macro.
I am populating a table (which happens to be in an Excel spreadsheet)
One column is the Article number 'xxxxx'. One of the other columns is
a 'Topic' which is typically three alphanumeric characters (like AA1,
AD4, BB4 DO6 etc.)
This is what i have to do
Step 1 - Jump to the page with the article number. Achieved by
p...how to edit Adobe file
how to edit Adobe file
Most certainly not in Word.
pdf files, I'm assuming that is what you mean by 'Adobe files', are 'fixed'
files. Their layout is frozen so they look the same on any machine and can
not be edited.
If you still want to edit such a pdf file, you will have to convert the file
to something else, edit it, and then save the result back as a pdf. The best
tool to do the conversion of pdf files to Word documents is probably Acrobat
Professional. Unfortunately, that is a rather expensive product to use for a
few simple conversions. There are ...Advanced Filtering
I've got a worksheet with four columns, one of which is a user name. I
would like to take all the user names that contain numbers (and their
respective data) and put it into a separate worksheet. So far, I
haven't had any luck doing this with any combination of wildcard
The format of the user names are two or three letters and then 4
numbers, or they are entirely text. So the list has data like abc1234,
ab1234 and abcdef. I want all the abc1234 and ab1234 entries in a
Thanks in advance.
Maybe you could use a helper column and filt...URGENT: Exporting table to an SQL script
I have a database in Access 2007 which I'm currently trying to rebuild in
SQL Server Express in Visual Studio.
Problem is, I can't seem to find an easy way of exporting tables. I've been
using copy/paste on the data, but that only works with simple tables where I
can build the table in SQLEx first.
Is there a way in Access 2007 (or an Add-in I can download) to export a
table as a list of SQL commands? Yknow.. CREATE TABLE, INSERT, etc!?
you can use upsizing wizard to export whole database, or Export tables to
ODBC connection to your sql server...Count invalid data entries
I am using the following macro to identify invalid data entries in
cells with data validation applied.
' Application.CommandBars("Formula Auditing").Visible = True
MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) &
" Configuration and Parts_TakeOff Sheets")
Is there a way to count the number of invalid data entries (red
circles) and write the number to a particular ce...