Why do I get this ###### instead of 11:00 p.m. in formatted cell?
Mon, 15 Sep 2008 10:43:07 -0700
...
|
How do I increase prices in excel by a percentage?
Mon, 15 Sep 2008 09:58:08 -0700
I read the postings by other users, which sound like they work great, but I
am in Excel 2007 and I can't FIND Edit, Paste Special...can anyone tell me
how to do this in Excel office 2007?
Thanks,
Jana Burch ...
|
Calculation
Mon, 15 Sep 2008 05:06:00 -0700
Can u pls solve this
Packs Quantity Total
500Kg 10 #VALUE!
i need the total value as 5000Kg
...
|
How do I calculate a percentage of a column?
Sun, 14 Sep 2008 23:34:01 -0700
I'm using Excel 2002 and have 3 columns. Column B is a series of Y's and N's
(Yes/No). At the bottom of the column, I would like to calculate the
percentage of Y's.
This sheet is a completeness report, so knowing how much work is complete in
percentage would be helpful.
Thanks ...
|
Chart options grayed out in Excel 2007
Sun, 14 Sep 2008 22:40:03 -0400
I have an excel file with many sheets in it. One entitled "eom proj" which I
had a graph in it with my end of month projections until the end of the
year. I noticed today that someone had removed the graph, but when I tried
to insert another chart, all the options had been grayed out. The sheet is
not protec ...
|
need help in adding a ' in front of a column of numbers
Sun, 14 Sep 2008 03:39:01 -0700
From what I read, a macro does not recored keystrokes. I'm new at this so
bear with me. I have found out that I can make numbers read as text by
adding a ' in front of the number Exa, '3331 '3331-6 '3331-25 so after doing
a sort as text the numbers will be in proper order. I have a column of part
numbers th ...
|
Is it possible??
Fri, 12 Sep 2008 23:34:01 -0700
I am trying to create a new vehicle log for my work place. I want to be able
to enter a vehicle number like 008 and have the name, and type of vehicle to
automatically fill out on the worksheet. Is that possible and how would I go
about doing it. Many thanks ...
|
|
|
group workbooks/files to make global changes?
Fri, 12 Sep 2008 14:05:01 -0700
Can this be done ?
I have several workbooks / xls files . They have the same format /setup so
I would like to make a change to a formulae in one on say cell B3 and have
the change be made across all the other workbooks/ files.
Your help appreciated
Mike ...
|
Formula needed for Sum(A1:C1) then Sum(D1:F1) in next cell
Fri, 12 Sep 2008 10:15:01 -0700
I am converting a monthly revenue table to a quarterly revenue table. I would
like to add A1:C1 and put it the result in a new cell and then autofill the
cell to the right of it so that it automatically adds D1:F1 for the next value
A B C D E F
1 Jan Feb March April May June
2 ...
|
Read Only pages
Fri, 12 Sep 2008 09:43:01 -0700
How can I cancel a page saved read-only. Somehow the programs opens all pages
as read only. I tryed to open the properties and un-click read only, but the
forms still indicate read only. ...
|
