formula required
Fri, 19 Mar 2010 12:40:01 -0700
Dera plz solve my problem, i m working in a bank my query is that
Today is 9-mar-10 my ending balance is 10,0000.00 in sheet 1 column A2 . and
this balance automatically will insert sheet2 under (ENDING BALANCE)
I want that next day on 10-MAR-10 my ending balance will that i will put in
Sheet 1 coulmn (A2 )s ...
|
eliminating decimal places
Fri, 19 Mar 2010 08:02:01 -0700
On an excel spreadsheet downloaded from an external source there are eight
decimal places in the numbers. If I format to two decimals it displays the
number with two decimals but still keeps the eight decimals when in the cell.
This makes it difficult to upload the info into our ERP system as that system
rou ...
|
Analysing data from several excel workbooks
Fri, 19 Mar 2010 03:01:01 -0700
Hi,
I'm totally new to excel and i need to analyse the changes in a funding
position across several years in a seperate excel sheet.
As in, submissions are made year on year showing the amount of revenue spent
on several different services. I need to be able to compare how those have
moved over the last ...
|
highest value between rows
Fri, 19 Mar 2010 00:26:01 -0700
hi..
Datas are:
A B C D E
1 AA08 AA07 AA09 AA30
2
I want to display the highest value(AA30) in E1. Any formula for this?
Thanks.
...
|
VBA code needed
Thu, 18 Mar 2010 23:34:01 -0700
i am trying to retrieve a range of data (the stock code of different phones)
from worksheet("Inventory") based on the name of the branches of where the
phones are stored.
worksheet("Inventory") has branch (Column A) and stock code (Column B)
i have 2 combobox.
combobox1 contains values (name of branches) ...
|
Navigation Questions
Thu, 18 Mar 2010 10:58:45 -0700 (PDT)
I am using W XP & Excel 2003.
I am entering latitudes and longitudes into a workbook. What I would
like to know is whether Excel can compute the distance between any 2
locations? Also can Excel convert a coordinate in latitude and
longitude format into a coordinate in UTM format?
Thanks for the help. ...
|
Why does an Excel 2007 file lose its format when reopened?
Thu, 18 Mar 2010 08:07:01 -0700
An Excel 2007 file (e.g. File.xlsx) loses its formatting when it is reopened. ...
|
|
|
addins
Thu, 18 Mar 2010 12:43:51 -0000
Hello,
I use the TM 'Autochart' addin, and I have version 2.1. The latest version
is 3.1.
I am suddenly having problems with autochart so want to try upgrading. Do I
need to 'uninstall' or delete the current version I have, or do I just
download the new vesrsion ?
Thanks
KK
...
|
spreadsheet
Wed, 17 Mar 2010 13:25:17 -0700
i have my payroll set up on the spreadsheet in excell. when i need to change something in my columns, such as hours some of the columns don't subtotal anymore how do i fix it so it subtotals
JBeaucaire wrote:
1) Select ALL the columns that make up the data set, not just one column2) Do
06-Nov-09
1) Sel ...
|
excel file will not open
Wed, 17 Mar 2010 08:19:03 -0700
i had excel 2003 we went excel 2007 . excel 2003 work good now all of sudden
2007 excel will not open the csv file iam useing at this time iuncheck
"IGNORE OTHER APPLICATIONS " stell will not open when i doubel-click it comes
up worksheet is gray out can you help ...
|
