Showing 0 after decimal with ROUND
I'm using the ROUND function like this:
=ROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
Unfortunately, if the numeral after the decimal is a 0, then it doesn't
display. How can I force a 0 to display after the decimal?
Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.
Hope this helps.
On Dec 4, 1:44=A0pm, Libby <Li...@discussions.microsoft.com> wrote:
> I'm using the ROUND function like this:
> =3DROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
> Unfortuna...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...users with restricted access
We have some users that we have directed to only get their information
from a report that has been set up. Because of that, I set up a
parameter query to make the information more easy to see.
The parameter query prompts for last name or broker #, is there a
way, when the last name is entered to include Jr's & Sr's? Or should
this be another field in the table to make the last name field more
...Office 2007 forms
I am creating a form with office 2007, will those people who do not use
office 2007 be able to fill in my form? should I save it in a particular
Provided you start from the normal template, don't use fonts that were
introduced with Word 2007, and save the form in Word 97-2003 document
format, anyone with Word 97 or later should be able to open it. Use only the
legacy form fields, to which end
http://gregmaxey.mvps.org/Classic%20Form%20Controls.htm will make things
<>>< ><<> ><<> <>>< ><<...C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...Adding support for mfc / atl types in a Win32 project
MSDN says this about adding support for classes shared between atl &
mfc (I'm just after points and rects btw)... just add the header (
I'm getting linker errors for these classes though. Is there a lib I
need to add? Any screwy build options need changing? It's in VC 2003.
In the project wizard I note that atl and mfc support aren't available
when creating an empty Win32 application.
On 26 May 2006 07:42:09 -0700, Simon L wrote:
> MSDN says this about adding support for classes shared between atl &
> mfc (I'm just after points and rect...User unknown
I made a new user on the exchange server, but if i want
to make the account in outlook, Outlook says: "the name
could not be matched to a name in the adresslist" I don't
know what to do anymore. All the rights are the same as
my collegea. can somebody help me?
Go back to AD where you created the account, preferably
on the Exchange Server. Is there an email address listed?
If there isn't then right click on the Recipient Update
Service in ESM and click update now.
Advise what happens then...
>I made a new user on the exchange server, b...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Performance By Investment Account
I've been trying to analyze the return calculations that MS Money
provides in both the Portfolio Manager and also the Performance by
One curious thing that I've come across and had previously not paid
attention to is a feature in the Performance by Investment Account.
If you click on "Customize' for this report, under the "Rows &
Columns" tab there is a customizable setting called "Do not show
performance based on data of less than: xx days." It defaults to 90
Does anyone know if this feature actually does anything? I'v...adding extra marker styles
how do we add extra marker styles into an excel chart? we have used all the
ones it has given us in 2003, but there use3d to be many more in 2002, how do
we get them back?
Here is an explanation on how to add custom markers.
I don't think the marker style have changed since xl2000.
> how do we add extra marker styles into an excel chart? we have used all the
> ones it has given us in 2003, but there use3d to be many more in 2002, how do
> we get them back?
Andy Pope, Micro...How to split an account into two accounts
8 years ago I started my 403B and 401A retirement accounts with Fidelity
as a single account. It did not both me that the paper showed them as
two accounts and I should have fixed it sooner. Now that Fidelity is
allowing me to download the information it is clear that I should have
two accounts. However I have purchased 4 mutal funds every two weeks for
the past 8 years and now to split them it appears I need to move 2 of
these sets of fund transactionss to a the account. The move one
transaction at a time is growing old. Is their an easy way or to
accomlish a mass move of all transac...Can't re-enter a previously deleted User ID
We changed the spelling of a User ID (applewicks to appelwicks) and then
deleted it (since he couldn't remember his password and the button for
password was greyed out so we couldn't change it.) And now we can't re-enter
the same user ID even though it doesn't appear in the window any longer.
Here is the error we get: ODBC SQL server driver: The log in appelwicks
already exists. Thanks!
I believe you have to delete the old ID through Enterprise Manager as well.
> We changed the spelling of a User ID (applewicks to appelwicks) and then
...Setting Defaults in New Item Wizard
How can I set a default value in the New Item Wizard? I want to always use a
barcode type that is about 10 down from the top and I want Taxable Item to
always be checked. Help...
Good question, I need an answer too.
"A StanTech Associate" wrote:
> How can I set a default value in the New Item Wizard? I want to always use a
> barcode type that is about 10 down from the top and I want Taxable Item to
> always be checked. Help...
You can set the default sales tax under Manager, File, Configuration, Sales
Tax, Default item tax group.
To set a default barcode type yo...Shared email account
I am new XP user. I have set up separate XP accounts for me and for my
wife. I would like to have both of us to be able to use the same Outlook
email address. How do I set up Outlook so that the 2 XP accounts look at the
same Inbox, Sent Items, Address Book, etc.?
Locate the pst-file for the account that now has all the e-mails in it.
Move the pst-file to a location both can reach (for instance C:\Outlook)
Start Outlook fot that user and it will prompt you for the new location.
Once configured close Outlook for that user and logon as the other user
Open Outlook and choo...Question for Bob Phillips re Splitting Names from Cells
You gave the answers below for splitting names from cells:
Using these formulas on this example John A Doe results in John A an
Doe, is it possible to split it to show John / A / Doe in 3 separat
cells, I know I could use the formulas again on the John A result t
split them but I'd like to do it in 1 go
If possible could...new activity not in the appropriate queue
I installed the Rollup 3 for MS CRM 4 and since then all created activities
are redirected to the users assigned folder in queue and not in progress(my
current activities) folder!
It's not logical because a new activity is not yet assigned to a different
user to be in the assigned folder !!
I can't believe this is on purpose and I DON'T have a workflow on this.
Can someone tell me how to fix this?
...Items for review wont show up
I am using MS Money 2004 Small Business. My checking account balance is
downloaded each day from my bank. For the last couple days, it continues to
download transactions, and tells me that there are now 8 items to review,
but when I open up the account, nothing is bold faced to review. On the
pane to the left, it still lists 8 items to review. I even went to the bank
website and downloaded in the most recent transactions, but this only made
the list of items to review larger. I still can't accept any of them. I
have tried a quick repair. I also tried restoring the back up, bu...Default User object security
Windows 2003 SP2
I am trying to fix a problem where delegation of control is not working
properly to usr OUs. I ca't seem to keep permissions on user account objects
that allow user accounts to be moved between OUs. I think it may be related
to protected account membership on the user objects themselves. ALso the
"inherit permissions from parent" is unchecked on user objects. Certain user
new user objects work fine and are inheriting. What are the default security
to use on user objects so that i can remvoe membership from protected groups
and how should I a...how to know how many e-mail each user receives per day?
We are running Exchange 2003 on Windows 2003. I would like to know how to get
an average of how many e-mails each users send and receives per day.
...calendar for multiple time zone users: all day events
Users in different time zones post absences and meetings to a shared company
calendar. When an all day event is scheduled in one time zone, it shows as
spanning two days for other time zone users. How do we make this work
For the others it does intrude on a second day.
> Users in different time zones post absences and meetings to a shared company
> calendar. When an all day event is scheduled in one time zone, it shows as
> spanning two days for other time zone users. How do we make this work
Until you upgrade to Outlook...Change Domain Name on outgoing Emails
Our company just purchased another company with their own Exchange Server and
AD infrastrure. We want all users in this new facility to have Email
addresses with our Domain such as firstname.lastname@example.org instead of their current
Domain email@example.com. Until I migrate resources from their Forest into
our Forest I have created contacts to forward all Emails from the abc Domain
to the 123 Domain. When users reply or send Emails from the 123 Domain it
still has their firstname.lastname@example.org Email address which will cause confusion
with our customers and suppliers. How do I force their Emails to us...Admin Account
Why do I see my administrator account logging on to every
mailbox in the Event Viewer when I reboot. Also, the login
list shows my admin account logged into many mailboxes. Is
"Myrick" <email@example.com> wrote:
>Why do I see my administrator account logging on to every
>mailbox in the Event Viewer when I reboot. Also, the login
>list shows my admin account logged into many mailboxes. Is
Probably because you've got some sort of software that's accessing
those mailboxes (like some AV software might do), and it's runn...