format changes when copying from one cell to another
I'm sure this is simple, but it is not clear to me...
I am copying the contents of a group of cells that exist on one worksheet to
another. In Sheet2, I tell cell A1 that it should equal Sheet1's A1 value.
That works fine. But if the cell is blank on Sheet1, it comes up as "0" on
Sheet2. I figured it was probably assuming numeric formatting, but when I
right-click > format cell on both Sheet1 and Sheet2, both show up as
"general", so why would Sheet2 take a blank value and populate it with "0"
I gather than you are putting a formula in one...How do I chart date ranges with varying start and finish dates?
I want to create a chart that on one axis will show date ranges that have
varying start and finish dates. The other axis is a list of project names.
Example: Project #1, starts 5/1/05, ends 10/1/05; Project #2 starts 3/5/05,
ends 2/2/06, etc. I want a bar chart that I can sort. Any help is very
appreciated. : )
It sounds like you need to create a Gantt chart. Here are some resources
that might help:
----...Format Issue of Windows Mail and M.S. Group
When clicking to open any mails including this site, MS Newsgroup, top
right pane of 'X' part is not visible.
In the past, I used 'Shove-It' program that was found on the web-site,
priced $15 that corrected this issue. However, this program is no longer
effective, thus it went back to the original format, .... not fully opening
content of mail of right side of pane, although I can read any mails by
using 'maximizing bvutton' to open in full.
Any imputs on this, above would be greatly appreciated.
"Winter10" <Winter10No...Date format in a report
The date is formatted in my table in yyyy/mmm/dd. In one report I need to
run for another organization the format needs to be in dd/mmm/yyyy format.
How can I change the way it displays in the report? I do not want to change
it in the table as I generally want the format to be yyyy/mmm/dd.
You can simply use either the format property for the control or you can use
the Format() if you need to set the format to something that doesn't already
Hope this helps,
If I want my chart to read from 50 to 100 instead of 0 to 100 How do I do
Be Nice to Everyone Everyday
Be Nice to Everyone Everyday
"jr" <email@example.com> wrote in message
> double click on the current chart axis values on the
> desired chart axis. You can set the scale in the popup
> >-----Original Message-----
> >If I want my chart to read from 50 to 100 instead of 0
> to 100 How do I do
> >...Reformat data to vertical format
Here is what I am trying to do.
I have about a thousand records that I need in a vertical format with
normal shared field name. Any suggestions
Psydwaze's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2437
View this thread: http://www.excelforum.com/showthread.php?threadid=37965
Creating a Spreadsheet from Database data (#dbdata)
http://www.mvps.org/dmcritchie/excel/snakecol.htm...pivot table %
I have 2 columns in a pivot table - decription and
amount. I need to calc a % of each value of the total.
I don't know how to do that.
...String Table (VC6 IDE)
I have strings in English language in the "String Table" of my project
(myProject.rc). I'm loading them using:
Now, I need to internationalise my app. How can I do that? How can I add
support for multiple languages? Which is the best way to do that?
>I have strings in English language in the "String Table" of my project
>(myProject.rc). I'm loading them using:
>Now, I need to internationalise my app. How can I do that? How can I add
>support for multiple lang...How to slant cells in Excel on top of chart at about 45 degrees
Trying to make a chart and slant cells at the top at about a 45 degree angle
with borders and still be able to type into it. Is this possible?
> Trying to make a chart and slant cells at the top at about a 45 degree
> with borders and still be able to type into it. Is this possible?
Try Format > Cells > Alignment Tab and set the Orientation to 45
Paul Sheppard's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2...Line Graph with two different data points
I am trying to create a line chart with numbers from my product Vs a
competitor. The problem i am having is how can i make a chart that will have
four data points comparing to each other? For example
Product A- 1.5 1.2 1.6 1.8
Product B- 2.0 1.1 1.2 1.3
Product A- 70% 20 % 30% 67%
Product B- 65% 30% 65% 55%
How do i get all of these numbers on one chart? Is a line chart correct. I
want to see these numbers compared??
Thank you so much
Since the number don't appear related to the percentages you might plot them
on the same chart but two different axes. If they were relate...Can Line Chart Overlaps be Highlighted?
Can the overlap portion(s) of two lines in a chart be shown in a different
color, without having to manually draw a shape? I would like to show the
areas where Line A is above Line B as red, and the areas where it crosses
below in blue - is it possible to do this without manually drawing in shapes?
To some extent it depends how many times the lines cross. If it's just the
once then you can use area charts to provide the shading.
This may help if the used one line as a base line...format negative dollars
We have 2 computers in this office, both with Office XP
On one we get ($ 4.00) on the other we get -$ 4.00 This
format seems to vary from file to files. Is there a way
to set the default on Excel to ($ 4.00) ?
It might help to check the Regional Settings in the
Control Panel (I assume your using windows). It
has settings for currency and number displays
which will affect excel. Check if yours and your
co-workers settings are the same.
"doug loewen" <firstname.lastname@example.org> wrote in message news:email@example.com...
> W...Data changes when Analyzed with Excel
I have a query with 3 tables that represent master item list, count qty and
as qty. When I look at the results in Query, all is well and accurate yet
when I select Analyze with Excel, values change. For example, if a record
shows zero qty in the as of field and zero quantity in the count field, I get
a value in one or both of the fields that origianlly were zero. Other than
linking the tables and grouping by master item list (to show all parts
regardless of qty's), there are no formulas or expressions in this query.
One of the tables is linked to a FoxPro table via ODBC driver.
...outlook 2003 inbox format
How can I eliminate the "Today", "Yesterday", "Last Week", etc? I much
prefer the look of Outlook 2000.
View > Arrange By > Show in groups
"Trng Administrator" <Trng Administrator@discussions.microsoft.com> wrote in
> How can I eliminate the "Today", "Yesterday", "Last Week", etc? I much
> prefer the look of Outlook 2000.
> Thank you
neo [mvp outlook] wrote:
> View > Arrange By > Show in groups
That...Duplicate entries & Conditional Formatting
Is there a formula indicate duplicate data on 2 different worksheets? I
want the font to change to bold.
Yes, provided it is a named range within the same workbook.
Select the cells and Format>Conditional Formatting>Formula Is>
Format for the change if TRUE.
Greeting from the Gulf Coast!
"hmm" <firstname.lastname@example.org> wrote in message news:3FCCCF2F.42E759CF@hmm.com...
> Is there a formula indicate duplicate data on 2 different worksheets? I
> want the font to change to bold.
...Help me create sales chart based on state and quantity
We have a production report on excel. It shows the details for our clients.
Part of that data includes the state in which the client lives. We are trying
to create a chart showing the percentages of each state( so we know where the
most deals are closed)
this sounds like a job for a pivot table, using Average as the data
Or, depending on your version of Excel, you can use AVERAGEIFS (in Excel
2007) or calculate an averate with a combination of SUMIF divided by
To be more specific, it would help to s...Powerpoint with Excel formatted information
My team has an excel file with Text and Icons in a status report format.
We use it to copy and insert paste into Powerpoint. After copying into
Powerpoint, I try to select it and edit but powerpoint gives an error that
"There isn't enough memory available to read the Excel file"
Other team members use this same excel template and powerpoint and they can
edit the information after it is copied to powerpoint. And I can use their
files and they work fine. Only one team member has this issue so somehow
this person's excel file is using a massi...no change pivot item.
i want to can not change pivotitems in the pivotfields.
namely pivotitems restircted.
How can I do in VBA?
*** Sent via Developersdex http://www.developersdex.com ***
...Conversion Errors Table
I'm new to working with Access, I just converted an Access 97 databas
into Access 2002. It tells me there were errors, and to look at th
Conversion Errors Table. But nowhere in the message or in the MS Hel
is there anything telling me where to find this table. Can someon
pshaw's Profile: http://www.officehelp.in/member.php?userid=493
View this thread: http://www.officehelp.in/showthread.php?t=125029
Posted from - http://www.officehelp.i
I'd expect to find it in the new...if value not found in table ?
I need to display a msgbox if a value is not found in a table.
If value not_in table.field then
I know that code wont work is just an ilustration of what i am looking
Thanks in advance
Use DLookup() to see if the value is in the table.
If it's not found, the result will be Null.
So, use IsNull() to test the result.
Here's how to get your Dlookup() expression working:
Getting a value from a table: DLookup()
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access us...Query cross two table
I have two tables, tbAdmission and tbCode. In my tbAdmission, I have Code1,
Code2 and Code3. In my tbCode, I have Code, Description1 and Description2.
In my Form, frmAdmission, I have txtCode1, txtCode2 and txtCode3 that are
all bounded to tbAdmission. And txtDescription1Code1, txtDescription2Code1,
txtDescription1Code2, txtDescription2Code2, txtDescription1Code3 and
txtDescription2Code3 that are unbounded and only for displaying the
txtCode1, txtCode2 and txtCode3 all refer to Code in tbCode to retrieve
Description1 and Description2 for displaying in the unbou...time line in chart
How do I put a vertical line in a chart in excel at a given point? i.e.
I know this is too elementary, but go from here:
You have a scatter chart from A1:B6
(X A1:A6; Y B1:B6)
A 2nd source series is A8:B9
(X A8:A9; Y B8:B9)
giving you the a vertical line at X=13.
"jon" <email@example.com> wrote:
>How do I put a vertical line in a chart in excel at a given point? i.e.
----== Posted via Pronews.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.prone...Transferring Field from Existing Table/limitations and change of d
Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID as the primary key. The
smaller table contains one field that lists a subset of these Employee ID
numbers (a selection of certain employees). I need to transfer this field to
the larger table, but I do not know how to tell Access to match up the
corresponding numbers (i.e., the large table lists all employees, bu...Sorting Data Automatically
I am importing text into a new worksheet and would like to run a macro
that can perform labour a labour intensive sort/deletion.
Column A contains a mixture of text strings as follows:
What I would like to do is determine how many QR's have associated
QT's and how many QR's are remaining that dont have associated QT's.
Any assistance would be greatly appreciated.
not sure how the sorting comes into this - sounds more like needing a
formula to count when a cell contains both QR & QT as op...Help on adding values to a bar chart
Here is my problem. I currently have a bar chart that has 8 X-axis
bars. I need to add 2 more to the X-axis. The labels for the x-axis
are based on cells within another spreadsheet, but are not consecutive
cells, they are spread apart. So when I go to add the two more cells,
I can only add one. When I click on the second cell to add it to the
list, all of the previous cells get unselected. I have even tried to
manually add these two values in. Is there a limit to how many values
can be on the X-axis? Please Help!!!
To select non-consecutive cells: select first cell, h...