Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Keyboard Shortcut15 Jun 2007 15:09 GMT1
hi. is there a keyboard shortcut to adjust the row or column width?
Autoexecute macro15 Jun 2007 15:09 GMT3
What I need it this,
As soon as a user opens a specific file, the macro ( in vba), creates
another worksheet, inserts 3 columns and makes the first column auto
numbered. I am sure this isn't hard. But I am a "newbie" to this.
organizing series data 34 items15 Jun 2007 15:04 GMT4
I've created a 2 axis line chart that tracks 17 locations in sales and
traffic.  I want to keep the sales and traffic series for each location
together in the legend. I cannot keep them together they keep seperating into
1- 17 sales and 1-17 traffic.  the organize series option ...
prevent schientific notation15 Jun 2007 14:45 GMT1
I have a vb program that takes a skeleton xls file with a few rows of
headers and an sql command to obtaiin data, and then populates the
spreadsheet. The number of rows and columns varies as does the type of
data in each row.
How do I format a figure as cent (e.g. 0.015 displayed as 1.15)15 Jun 2007 14:41 GMT1
I would like to format number expressed in Euro (same with Dollars) in cent.
e.g. instead of having "0.0123 €" I would like to see "1.23 ct"
Using percentage symbol I get the right figures but with the wrong symbol:
format: "0.00 %" -->> figure is displayed as "1.23 %"
macro code to get dynamic range15 Jun 2007 14:41 GMT3
Hi Friends,
I am trying to write a macro to find if a range consists of same
values or not
Eg
how do I transfer data from one sheet to another with VB code15 Jun 2007 13:40 GMT2
I am a novice when it comes to programming. I am trying to make a simple
accounting systems. I would like to:
Fill in data on one sheet
run a macro
copying formulas15 Jun 2007 13:34 GMT7
I'm a self-taught Excel user (semi-intermediate level), although I'm having a
"formula" problem:
When I copy the "value" of a cell from cell A (which contains a formula)….
And paste special to cell B (for value only)…. I don't want the contents in
future value15 Jun 2007 13:12 GMT1
I am getting a negative return on my answer.  The question was,
I have a PV now of £10,500.00
Leaving in as an investment for 15 years
Interest rate per anum 5%
Using "Countif" in macro gives compile error15 Jun 2007 12:23 GMT4
Hi to all,
I dont know why following line of code in my macro is giving a compile
error
Single line Code >>>
Currency format in visual basic text box15 Jun 2007 11:47 GMT2
This is probably a very silly questiong but i can't find how to solve it.
I have made a form that you enter in data and it puts it into cells on a
spreadsheet, some of it is a numerical amount. These amounts are then
referred to in other formulas. Despite the cells being in the ...
possible to calculate % attainment using one formula?15 Jun 2007 11:07 GMT6
I need to measure one set of data over the other. For example, Set A is
forecast and Set B is actuals.  
Set A   591     107     (160)    (559)    (159)
Set B   362     (24)    50     (121)    (295)
Healing/recompiling corrupted Excel files?15 Jun 2007 11:00 GMT2
I have an Excel file that I suspect has some element of corruption
associated with the file.  It basically a data processor I have been
developing intended for general use that accepts in data and
manipulates it with prodigious use of formulas, pivot tables, macros
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?15 Jun 2007 10:42 GMT4
Every time Ia file is closed in Excel 2007, the program asks if I want
to save any changes made to the file, even if the file was not
modified. This happens even if just viewing an excel attachment in
Outlook.
Dates don't appear properly after downloading data from Accounting15 Jun 2007 10:18 GMT4
I have a report in an accounting program called MYOB. I chose to export the
report to Excel 2003. However, Excel shows the dates (found under one column)
in two different formats. i.e. some of the dates appear in this format
(04-April-2007), while others appear in another format ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.