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...How can I get 32-bit Integers?
I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
is just 16 bits, i.e. its max value is 32,767. How can I configure it so as
to have 32-bit Integers, along with 64-bit Longs?
"Renny Bosch" <firstname.lastname@example.org> wrote in message
> I am using Access MS Office 2007 with VBA 6.5, on Win XP. My Integer type
> is just 16 bits, i.e. its max value is 32,767. How can I configure it so
> as to have 32-bit Integers, along with 64-bit Longs?
An Access Integer is 16 bits. A Long Integer is...INTERNET MILLION DOLLARS
INTERNET MILLION DOLLARS - www.InternetMillionDollars.biz
Watch the VIDEO on YOUTUBE... NOW!
MAKE MONEY INSTANTLY using 2007 featured
INTERNET MILLION DOLLARS as a resource.
WORK FROM HOME
HOMEBASED JOBS AND IDEAS
Professor James Bradley's
"Quick and real way to make BIG MONEY on the Internet!"
Finally you have FOUND IT!
Make a FORTUNE each month...
.... every month!
100% ON AUTOPILOT
Read it NOW and CHANGE YOUR LIFE!
Are you fed up with being short of MONEY all the time?
Do you DREAM about a...Queries and Charts
Does anyone know why the expressions in queries work fine for reports but not
...How do I extend a underline across an entire cell?
When working on a financial statement, I was curious how to 1. Have a line
extend across an entire cell even if the number is only 2-3 digits and 2. How
to apply a double line under a number without using the = sign in the
Look on the formatting toolbar for Borders
Regards Ron de Bruin
"Lindsay" <Lindsay@discussions.microsoft.com> wrote in message news:F4C9ED6C-7F2D-4277-86CC-6FA46D315DA5@microsoft.com...
> When working on a financial statement, I was curious how to 1. Have a line
> extend across an entire ce...How do I get Powerpoint 2003 fade in 1 by 1 in 2007
I frequently used the 'fade in one by one' feature in Powerpoint 2003, which
allowed me to fade in individual bullet points by way of a click of a mouse.
Not only is this feature now not standard in 2007, but I can't work out how
to create it: anything that I find, tends, instead, to fade the bullet points
in on some kind of automatic time schedule, rather than - as I want - on a
mouse click. I want only to use text, no sounds, no pictures, and nothing
fancy. Currently, I am reduced to copying my material into an old Powerpoint
2003 presentation, but this is silly....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&...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...Events in Year view?
I'm trying to find XP software (perhaps Outlook) that shows events/
appointments in Year view.
Will Outlook do this, if so which versions?
If not, can you recommend other XP software that will?
What format do you want it in?
See http://www.slipstick.com/tutorials/yearlycal/yearlycal.asp for the only
type outlook supports.
Also, if you use outlook 2007, the calendar printing assistant can print
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by emai...fiscal year setting question
i know that the fiscal year settings get more or less set in stone, so i had
a quick question before i set it for my org.
in the template field, what is that used for? if i select 'quarterly', does
that mean i can only run reports on a quarter basis? what if i wanted to do
ultimately, my question is what is the 'template' field used for?
Fiscal year setting must be aligned to your company's accountig policy.
Fiscal year setting primarily defines sales quotas. When you set quarterly
periods, you can set quarterly quotas for mem...Can the data in a chart table be right justified?
Ecxel 2003 and previous versions of the product center the data in the data
columns. Can the data in the columns of a chart table be right justified?
In article <DABF738B-6C0D-458B-B082-FA9BD8F126A7@microsoft.com>, =?Utf-
8?B?c2FtIGVhZ2xl?= <sam email@example.com> says...
> Ecxel 2003 and previous versions of the product center the data in the data
> columns. Can the data in the columns of a chart table be right justified?
Have you tried to format the table? If yes, and you haven't been
successful it is probably because XL allows very limited cust...Data migration - Adventure Works
I have a company where the adventure works db has been used and had a
lot of data populated into the system. We have now purchased MSCRM and
have obtained the company reg keys.
What is the easiest way to get the data from the 1 system to the next?
We will be establishing a new AD domain and users for the new
Data Migration Framework?
Microsoft CRM MVP
I'm installing office 2003, outlook, I'm lost from server type to URL address
to server info? I have sbc yahoo dsl. can you help me?
damselindistress <firstname.lastname@example.org> wrote:
> I'm installing office 2003, outlook, I'm lost from server type to URL
> address to server info? I have sbc yahoo dsl. can you help me?
When you obtained your packet from SBC, they included all that information.
Moreover, it's in the Help section of SBC Yahoo's site. The most likely
settings are "pop.sbcglobal.yahoo.com" for the incoming serv...Updating a chart Automatically
Hi, i update a spreadsheet with new data from Access
everyweek. I have a chart that displays the last thrity
days, how do i do this automatically, so i dont have to
keep updating the chart manually ?
Thanks in advance Jay
Jay Richardson wrote:
> Hi, i update a spreadsheet with new data from Access
> everyweek. I have a chart that displays the last thrity
> days, how do i do this automatically, so i dont have to
> keep updating the chart manually ?
> Thanks in advance Jay
See www.tushar-mehta.com, Dynamic Charts.
dvt at psu dot edu
...how do you get a landscape page?
Please help, desperate!
If you are using 2010, Page Design tab, Size, More pre-set page sizes. Letter
landscape is the first choice.
In all other Publisher versions landscape will be on the page setup screen found
in the File menu.
"becky.x" <email@example.com> wrote in message
> Please help, desperate!
...How do I set up a 98% baseline across my chart?
I am trying to show on a bar chart the baseline that represents SLA
requirement of system up time of 98%. How do I do this?
You can find information on adding a datum line here.
Andy Pope, Microsoft MVP - Excel
"Deb" <Deb@discussions.microsoft.com> wrote in message
>I am trying to show on a bar chart the baseline that represents SLA
> requirement of system up time of 98%. How do I do this?
...Label a chart of counts with other percentage data
Here's the data:
Group 2005 2006 2007 LTM Data
A 19.4% 22.8% 21.2% 19.9% Profitability
A 6 7 7 7 Count
B 9.5% 31.6% 30.4% 30.7% Profitability
B 2 3 3 3 Count
C 22.4% 23.6% 16.6% 17.6% Profitability
C 15 16 17 18 Count
D 19.2% 20.5% 15.9% 13.7% Profitability
D 8 8 9 10 Count
I have successfully generated a stacked bar chart that shows the counts per
group by year.
Now I would like to include a label for each group to show profitability for
each group in each year in the 4 stacks. How would I do that?
--...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...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...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...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?
...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Chart Linking
How can a cell in one workbook be linked to data in another workbook.
try the following:
- open both workbooks
- in the target workbook enter the equatrion sign '='
- now select with your mouse the source cell in the other workbook and
"Kenneth" <firstname.lastname@example.org> schrieb im Newsbeitrag
> How can a cell in one workbook be linked to data in another workbook.
Or copy the source cell, select the target cell, choose Paste Special
from the Ed...