Money 2006...Multiple fund numbers but only one account number
I have several differents funds held at the same investing institution. When
I try to set-up online services for one of these accounts Money only allows
me to set-up one fund at a time. I need to set-up all of the funds at the
same time but I can't figure it out. If I set up one fund from an account
online updates occur, but only for that fund not the entire portfolio. Any
In microsoft.public.money, KenTiffJelt wrote:
>I have several differents funds held at the same investing institution. When
>I try to set-up online services for one of these accounts Money...All my Reminders are gone? Is there a way to get them back?
All my Reminders are gone? Is there a way to get them back? Some backup
folder or something? I am sharing this computer, so I don't really know what
Did someone turn the Reminder option off? If so, you can turn it back on for
future reminders but past due reminders are dismissed forever.
Look in Tools, Options, Other, Advanced, Reminder options - you need display
the reminder checked.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
...custom text fields
I know that Project 2007 can handle a text field (#1-30) of up to 255
characters but when I go to add that field to the Task Sheet, it
limits me to 128 characters. Any clues? I really need the whole 255
...change the text in the legend of a chart w/o changing pivot text
I am trying to create a series of pie charts that compares demographic data
for clients assisted with multiple housing-related activities (new homebuyer,
rehab, foreclosure prevention, etc.) If I want to look at the age of new
homebuyers, on my pivot table I deselect all activities except new homebuyer.
After I make my pie chart, in the legend the labels are "new homebuyer
18-24", "new homebuyer 25-34", etc. It's pretty self-explanatory that these
are all "new homebuyers". I need for the New Homebuyer part to not be shown
in the legend, but I can...Text Form Fields
Not sure if I have posted this in the right area, but here goes. I am more
familiar with excel so working with forms in word is new to me. I have been
tasked with developing a number of forms at work in Word 2003 for posting on
our website. A guy who left, and is now not contactable, developed a whole
range of forms before he left. He made sure the forms could be filled in
online by inserting text editable fields for client use (both the 'greyed
out' section and dotted lines can be seen when viewing and completing online
and the dotted lines auto-delete as text is inserte...Determine cells that drive conditional formatting?
Cells A1:A4 have conditional formatting set up that states if they are equal
to cell A10 they will be highlighted yellow.
Is there a way to quickly see what cells drive conditional formatting? In
other words, we can use Edit -> Go To Special to see which cells have
conditional formatting applied; however, this doesn't show us that A10 is
involved. Since there isn't a formula directly involved, we can't trace
precedents/dependents. Can we only know that A10 is involved in the
formatting of A1:A4 by selecting those cells and going into the conditional
format...Count "," in a cell
Is it possible to count "," in a cell please?
I used this ... but does not work
Say below ... can it be solved?
Remember to Click Yes, if this post helps!
"Elton Law" wrote:
> Dear expert,
> Is it possible to count "," in a cell please?
> I used this ... but does not work
> =COUNTIF(FO93,",&qu...Deleting Sales Receipts
I need to reduce my db size...
Many have posted about the Retail Realms archiving utility. This sounds like
a great app, but since I'm somewhat familiar with the db schema in RMS and
know SQL, I would like to attempt it on my own.
Has anyone tried removing sales history through SQL? What tables should be
cleared, does anyone have a script that they use?
I understand that a backup should be made prior to any changes :)
To see what tables are taking up all the space run this query:
SELECT [total size KB], B.rows, O.name
FROM (select sum(convert(de...How to get info filled in automatically
I make a roster for my work with multiple items for each person. An example
of what I am looking to do: In cell A1, I have a drop down menu with all
employee's names. Cell B1 is for their ID number and cell C1 is for their
radio ID #. I wanted to see if their was a way for when I select a name in
the drop down menu of A1 for B1 and C1 to automatically fill with that
employees' respective ID numbers?
Let's say you have a list of employees with their relevant numbers on Sheet2
in cells A2:Cxxx
With your dropdown list in cell A2 of Sheet1, enter the followin...Conditional Formatting of Text...
....I know how to apply Conditional Formatting to cells containing numeric
data; is it possible to apply it to cells where the result is textual? For
In this instance, I would want to conditionally format this cell so that if
the result is High, then the text should be bold and red. Thanks in advance.
I'm using Excel 2002...
click on the cell
choose format / conditional formatting
cell value is
click the format button
set your formatting
click OK twice
"Birmangirl&quo...i need to have more text options in a running writting font
I have to format a logo from a hand written sign. The text "Script MT Bold"
is quite acceptable but the 'f' needs to have a loop on the bottom not on the
top. The dot above the 'i' needs to be round not square.
Is there any way I can develop the text that I need or change the actual
I have done the work in 2003 Publisher.
I use Brush Script MT and the letters are properly portrayed. The loop for
the "f" is on the bottom and the dot over the "i" looks rounds.
If I can be of help, send me a note to:
dschmidt AT pacifier DOT com
-...moving data from one sheet to another
I have records in sheet1 as follows:
A B C D E
1 NAME SEX SUBJECT COLLEGE WHETHER SELECTED
2 A MALE MATHS XAVIER YES
3 B FEMALE ENGLISH SEBASTIAN
4 C FEMALE MATHS PAULS
5 D MALE PHYSICS XAVIER YES
6 E MALE CHEMISTRY PAULS YES
7 F MALE PHYSICS SEBASTIAN YES
8 G FEMALE MATHS XAVIER YES
9 H MALE PHYSICS PAULS
10 I MALE MATHS SEBASTIAN
Now, I want to scan entire data upto last cell of the
range and move(cut and paste) those of the selected candidates, Sheet2
of the same book.After moving, the name o...text to fit in cell
How do I make the text fit in a cell. I want to be able
to print the page with all of the words in the cell even
if it has to make the cell larger, without going over
into the next cell. How do I do this?
goto 'Format - Cells - alignment' and check 'Wrap text'
> How do I make the text fit in a cell. I want to be able
> to print the page with all of the words in the cell even
> if it has to make the cell larger, without going over
> into the next cell. How do I do this?
Format>Cells>Alignm...1 Cell 2 Values?
Is it possible in excel to have it return two values in one cell separated
by a comma and spaces?
For example I want it to count the number of times in a month the value was
positive and the number of times a value was negative and in the cell I want
it to show
A1: +, -
Is this possible?
Thanks to all,
>Is it possible in excel to have it return two values in one cell separated
>by a comma and spaces?
>For example I want it to count the number of times in a month the value was
>positive and the number of times a value was negative a...Totaling cells from separate worksheets to master form
If I have 2 separate worksheets with individual cell values and want the
total to show the sum of obth cells, how do I do it?
Suppose those values are in F10 on one sheet and in G6 of the other
sheet, then put this in the appropriate cell of your master sheet:
=3DSheet1!F10 + Sheet2!G6
to add them both together.
If your actual sheet names contain spaces you will need to include
apostophes around the sheet name, like:
=3D'First Sheet'!F10 + 'Second Sheet'!G6
Hope this helps.
On Apr 21, 10:31=A0pm, snake941 <snake...@discussions.micros...Filtering out text with conditional formatting
I have a problem I need help with. I have a worksheet that has
column with 13 digit long number in it.
I want a formula (or is it conditional formatting) that will highligh
the cell if the last 5 digits of the number are not �00000�
The number is in text format and needs to stay that way� so I wa
thinking there could be come way to examine the text .. I dunno� an
ideas greatly appreciated�
bluebean's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2595
View th...Winmail.Dat Being Created On Plain Text Emails
I am running Outlook 2003 with all the updates and I am having a winmail.dat
file created on every email that I send even the ones in Plain Text.
Are there other settings that I need to make in Outlook to stop this from
RB Data Services
Try turning off Word as your e-mail editor to see if it stops. (See Tool >
Options > Mail Format tab)
If Word is off, go to Tools > Options > Mail Format tab > Internet Options.
Make sure the dropdown in the middle of the dialog is not set to Outlook
Check the e-mail address...can't copy text to new pub document
I am trying to copy entire pages from one Publisher 2007 doc to another. It
will copy the text in some text boxes but not in others. I don't understand
why this is happening. How do I get it to copy the entire page as is? I am
using Ctrl A or Select All.
Oh, another thing to add: Even if I select only a single text box, it will
not copy any text.
> I am trying to copy entire pages from one Publisher 2007 doc to another. It
> will copy the text in some text boxes but not in others. I don't understand
> why this is happening. How d...Format Excel cells
Anyone could help me to solve this problem :
How to format the selected cells so that it allows other users to "paste
values" only(number from 0 to 100) to the cells. It rejects "paste" function
which put formula, format etc into the cells. Thanks a million !
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreade...cells changing from number to date
I am putting a number in a cell, then tabbing to the next cell, the previous
cell changed from a number to a date. How do I keep the number there?
What are you inputting, a fraction?if so, format as # ??/??
(remove nothere from the email address if mailing direct)
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote in
> I am putting a number in a cell, then tabbing to the next cell, the
> cell changed from a number to a date. How do I keep the number there?
...one sided posting entry in gp?
how would I create a one sided entry in GP to correct a double sided entry
that posted twice ( due to a system failer a month ago)? There used to be a
document on customer source; but i cant find it.
Thanks for any information
I'm unclear as to why you need a one sided entry instead of backing
out one of the double sided entries that posted incorrectly.
To backout one of those entries click "Correct" on the JE Transaction
Entry Screen (Transactions->Financial->General)
On Sep 18, 12:54 pm, 2020 <2...@discussions.microsoft.com> wro...How to get rid of the gridline? #2
slamm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1501
View this thread: http://www.excelforum.com/showthread.php?threadid=26636
...updates wont install get error message 643 & 636
how do I install them
> how do I install them
Which updates (listed by KB######)?
What Operating System?
What Service Pack level is your Operating System?
What architecture is your Operating System (32-bit or 64-bit?)
What antivirus software do you utilize?
What firewall software do you utilize?
What antispyware software do you utilize?
What is your backup plan like (backups of your important data to external
What have you tried in order to resolve your issue so far?
How To Ask Questions The Smart Way
http://...getting updated info from pivot tables
I created a pivot table with months as column and sum of clients an
sum of members as rows. I take the last month and Grand total number
to another table I use for reporting. Is there a formula that I ca
use to tell the table to get the last month (grand total - 1) and gran
total numbers so when I update the pivot I dont have to change the othe
table all the time.
Thanks for the help,
marksuza's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=265
View this ...Problem
I am having a strange issue with my excell file since a while. This is the
second year I am using it without problem. I start a workday with a new sheet
so every morning I just copy (Edit/Move or Copy Sheet) the latest sheet,
rename it and use it.
All of a suddent when I perform this operation I have a prompt that says "a
formula or sheet you want to move or copy contains the name 'aaa', which
exists in the destination worksheet. Do you want to use this version of the
I would hit yes to proceed, then I would get over 50 other prompts with