| Thread | Last Post | Replies |
|
| adding money amounts in excel | 25 Sep 2006 15:52 GMT | 1 |
I am using a formula to calculate 10% of an amount which is rounded off to 2 decimal places. The amount is $1,952.48 and it is rounded off to $195.25 which is what I want it to do. The problem I am encountering is when I click on the cell the actual value of the number is 195 ...
|
| Cell Format | 25 Sep 2006 15:34 GMT | 1 |
In Column A, I have a general categories of problems. (There happens to be 12 categories, which isn't important beyond letting you know there are multiple categories). In Column B I give examples of the problem. The examples are numbered. Is
|
| Problem trying to create a "values only" sheet | 25 Sep 2006 14:12 GMT | 2 |
I have a rather large spreadsheet full of basic data and a lot of derived statistics - the stats are in 1 of the worksheets. I want to be able to send to a number of folks ONLY the statistics sheet and in a values-only form. I did a "COPY" and "PASTE SPECIAL - VALUES" for the ...
|
| Identify Unique Items | 25 Sep 2006 11:08 GMT | 4 |
Consider the list below. I want to somehow count the number of unique assignments for each manager. Manager Assignments Fred Neil
|
| Changing Dates | 25 Sep 2006 09:00 GMT | 2 |
I am trying to figure out a way to auto-roll the dates on a spreadsheet forward. Basically, what I have is this: A1 B1 C1 D1 09/25 10/01 10/08 10/15
|
| How do I reference a RANGE inside a Cell Formula? | 25 Sep 2006 03:36 GMT | 1 |
Help ... I need to condense the following formula that's in multiple cells. While this example is for illustrative purposes ... my true cell formulas have reached the max character limit for a formula. So I'm desperate to find an alternate way to calculate the total number of
|
| sum a cell value over 75 | 25 Sep 2006 02:45 GMT | 7 |
Please help!! Excel beginner! I need to build a formula that will add any remaining value over 75 in a cell. For example:
|
| Shortcut Key or Macro for (Insert -> Entire Row) | 25 Sep 2006 02:23 GMT | 6 |
Is there a shortcut key or macro I could do that would automatically insert a new row? I'm getting tired of Right Click -> Insert -> Entire Row...
|
| unlimited | 25 Sep 2006 02:04 GMT | 1 |
how do i set a cell to unlimited characters? so i can enter more than 1024 charaters in (i need to enter about 5000 characters in one cell) Thank you
|
| Worksheet setup | 25 Sep 2006 01:23 GMT | 2 |
How do I set up a new worksheet overall 180 x 240 mm with cells 37 x 30 mm?
|
| move between pages with out scrolling | 25 Sep 2006 00:52 GMT | 2 |
I am currently using a 20 page spread sheet and i am new to this the only way i can move from one page to another is to scrool down through the pages is there a way to type in a page number a cell number or even the arrows that move you through the program easier any help ...
|
| convert column to a row | 25 Sep 2006 00:25 GMT | 1 |
I have a spreadsheet that has only one column of data. I'd like to convert it from a column to a row. Is this possible? How? Thanks!
|
| chart or macro problem | 24 Sep 2006 20:21 GMT | 4 |
problem: Have around 300 student records want to produce a chart for each one, the chart contains 4 pieces of data for each student and is unique to each student, I want to produce a seperate excel template for each student e.g. i will end up with 300 seperate excel files prefably
|
| Shortcut Ctrl-X not working on multiple cells | 24 Sep 2006 20:18 GMT | 2 |
In Excel 97, on some spreadsheets I can't use Ctrl-X to cut multiple cells at once. Other ways to cut work, but Ctrl-X is my preferred method. On other spreadsheets this does work. Has anyone ever seen this before?
|
| Excel 2000 Crashes | 24 Sep 2006 20:03 GMT | 2 |
I can open excel spreadsheets no problem. As soon as I try to change the font, or the font size, it crashes. Anyone have any ideas? Thanks
|