|
How do I set default for a column so that first letters are caps?
if a column is names, how do i set it so that the first letters are all caps?...
|
3 |
25.07.2006 19:46:10 |
|
|
How do you make titles for columns in worksheets?
I just want to make titles for columns in worksheets. I can't get
information on this no matter how I phrase the query....
|
4 |
25.07.2006 19:36:19 |
|
|
checkbook register
down loaded check book rei can't get checkbook register to do the math...
|
6 |
25.07.2006 19:21:07 |
|
|
Splitting an expense
Amature here!
Expense amount = 1,370.25 in A1
Client #1 owes 1/2 = $685.13 (A2)
Client #2 owes 1/2 = $685.12 (A3)
if I put the formula =A1/2 in A2, it returns $685.125, and then when I go to
formatting it rounds to $685.13 (Correct)
But then, using that same formula in A3, it gives me $685.13, when it should
be $685.12.
In A3, I tried using the formula =A1-A2, but it's still returning ...
|
5 |
25.07.2006 18:10:11 |
|
|
Sort by part of a number
I need to file by claim number where the number is P1- 358V-852
P1-358V-058
The correct order would be by the last three characters. Can this be done in
an easy way?
Thanking you in advance for any help.
Joe...
|
3 |
25.07.2006 17:48:03 |
|
|
Sorting numbers as Text
I frequently work with a lists of text data, some of which consists of digits
or digits + alpha characters. These are always formatted as tect fields.
When I sort them i get a dialog box asking if I would rather sort digits as
numbers or as text. Sorting as text provides the result I need, so I always
select that and it works fine
My question is, how can I skip having to answer this questi...
|
7 |
25.07.2006 16:46:17 |
|
|
show only the required part of the sheet
i want excell to display only the selected part of the sheet where there is
data in it and rest all should not be displayed. e.g. from a1 to aa155 should
only be displayed....
|
4 |
25.07.2006 15:35:52 |
|
|
Sum in numbers for text values
Help! I have been asked by work to create a spreadsheet for tracking the
number of companies we are speaking to. I need to calculate the total
number of companies in a certain column but some companies are listed
twice as we have different contacts in each company.
Do I need to somehow convert the text in to a numerical value in order
to total each column and how do I go about excluding duplic...
|
5 |
25.07.2006 14:49:32 |
|
|
access query reports to excel formatting help
hi. i am really very new in excel programming. i did not even knew that
we can do some programming in Excel until last week when i came up with
a problem. i hope you guys can help me out. but first let me tell you i
dont have no clue about programming in excel. so treat me like a newbie
and i will really appreciate that.
i have created a database in Msaccess. i have 3 buttons for my reports
bas...
|
2 |
25.07.2006 14:45:02 |
|
|
Format size of finished sheet?
An error with IE when I tried to post (hopefully this will not be a double
post)
I have created a sheet in Excel 2007 (beta) I would like to save the sheet
without the extra cells/rows etc I deleted pages 2&3 but can't remove the
extra sheet information when I only need to print and keep a compact sheet of
the data.
I have tried to copy etc but I am always presented with the full sheet...
|
7 |
25.07.2006 13:31:02 |
|
|
Help
In column (I) I have cost centres, which range from 2001 to 2042 and in
column (H) I have the number of days taken for payment. In cell AA4 and I
want to return all payments over 5 days belonging to cost centres
2033,2036,2037 & 2041.
Can you please help.
Monty
...
|
3 |
25.07.2006 12:55:28 |
|
|
Which trend line?
I need to interpolate some data points. But I am not sure which kind of trend
line should I draw?
There appears to be many different kind..
I do not need a super fanciful one. My main purpose is really to find the
trend (literally) so which one should i use? Polynomial? and also how do i
know how many order? (what is a order anyway?) I am sorry to ask such stupid
questions, but i am a ...
|
2 |
25.07.2006 12:32:42 |
|
|
Excel Tool Bars
Lately, when I open Excel, the top Excel name bar and the bottom tool bar are
not on the screen. It appears that the worksheet is too large to be contained
on the screen....
|
5 |
25.07.2006 03:58:02 |
|
|
quick key to go to formula bar
Is there a quick key for jumping from a cell to the formula bar?
thanks,
sb...
|
7 |
25.07.2006 03:11:00 |
|
|
calculating months
hello peeps i'm trying to calculate the number of months from a list of
increasing dates,
b3= 21-Jan-06
b4= 03-Feb-06
and so on
b16= 14-Jul-06
b17= and onwards ar blank
b25= DISPLAY No. MONTHS
i'll be adding more dates in cells b17 to b24 at a later date so would like
it to allow for this to happen
i enter the date as 14/8/06 and it gets displayed as 14-Jul-06 if that helps ?
i've ...
|
4 |
24.07.2006 21:33:48 |
|
|
go to sheet number
Errors are given in sheet numbers but the sheets have names not numbers.
How do you "go to" a sheet number? I have about 200 in a workbook.
Thanks
John...
|
6 |
24.07.2006 18:29:48 |
|
|
Help with a custom label?
I want to replace the default format for cell d18 with a custom label of
"Customers", I know i need to use the quotation marks around Customers but i
am unable to get it to work.
here is a sample of what i'm working on
$255 $20 $21 $22
10 (2,145) (1,845) (1,545)
12 (1,905) (1,545) (1,185)
14 (1,665) (1,245) (825)
16 (1,425) (945) (465)
18 (1,185) (645) (105)
I need the 255 to r...
|
3 |
24.07.2006 16:47:02 |
|
|
Williams/ACLCconference2006 in Excel
I can't seem to find the file labeled "Williams" in the Excel site and I'm
pretty sure I saved it when I finished it yesterday. Please somebody help me
as I am quite new at this other than typing!...
|
2 |
24.07.2006 14:25:02 |
|
|
Format data Sheet size?
I am working in Excel 2007 (beta)
I have created my sheet and was able to remove sheets 2 & 3 which I don't
need.
I would like to trim the size of the sheet and only print the contents of my
data but do not know how to remove the excess columns/rows which mae up a
full Excel sheet.
Is there a way of saving my sheet with only the cells I have data in
compacting my sheet for future refe...
|
5 |
24.07.2006 13:08:56 |
|
|
create a thin border around the selected cells
need information on excel 2003...
|
2 |
24.07.2006 12:53:01 |
|
|
League Table using Index
Hello all,
I've had a quick look around to see if this sort of question had been
asked before and couldn't find anything similar.
I'm fairly new to Excel and am trying to construct a footbal league
table with matches matches for 6 teams. So I have a array of the 6
teams, an array called Scores of 6 by 10 to hold each teams score in a
particular match, and a 20 by 3 array detailing the match...
|
3 |
24.07.2006 02:52:29 |
|
|
How to link Subtotal results?
How do i use subtotal function results from one worksheet in another
work sheet. I am able to work out average price of raw materals brought
but would liked it automatically linked to my profit forecast and actual
sales worksheet.
Or is there an easier way for me to have stock control and sales data
linked?
--
buggu
------------------------------------------------------------------------...
|
3 |
23.07.2006 20:47:59 |
|
|
Hierarchy in excel
Hello Friends
I am new member here ... right now i am struck with one prob in excel
We have 2 structures 1 st product structure & another is location
structure
In product Structure all locations are clustered together
eg Prods are : A, B C. & locations are 1,2,3 etc
Prod Structure Location structwould be
Total Total
A ...
|
2 |
23.07.2006 17:49:29 |
|
|
creating a table automatically
hi this is my first post, i'm fairly new to excel & i was hoping someone
could help me out.
i'm doing some computer work for my uncle & as i was going through
everything that needed doing & i came accross this excel problem. I'd
already created the document which is an operational status report.
when he asked me to set it up so that a section of the report would
automatically appear on each new ...
|
5 |
23.07.2006 17:41:11 |
|
|
Why do gridlines not print in Excel spreadsheet?
I tried to format a new spreadsheet to print gridlines on all cells with page
setup. When I then click on Print Preview, gridlines do not show. ...
|
6 |
23.07.2006 15:43:01 |