| Thread | Last Post | Replies |
|
| Date format | 15 Nov 2007 19:12 GMT | 1 |
Hi I want to convert 1530 into 15:30. Could anyone tell me the formula to do it. Thanks,
|
| Dividing cell by sum of two other cells | 15 Nov 2007 19:02 GMT | 2 |
I have three columns of figures, i.e.: A B C 8.53 1 47.83 I need a formula to divide 47.83 by the sum of 8.53 + 1. Can I do that
|
| How do I make Excel 2007 compatible to others on older MS systems | 15 Nov 2007 18:56 GMT | 2 |
Whenver I send an Excel 2007 attachment in an Email to others, they cannot read or sometimes even open the attachment, because apparently it is not compatible with older Windows Excel systems. This makes it impossible for me to send informartion in spreadsheet form to others who ...
|
| circular reference | 15 Nov 2007 18:56 GMT | 1 |
when I post my dollar amounts into the cells columns for some reason when I hit enter, the figures don't move over to the right of the cell as in past months. Also, when I try to insert $ and ,'s they don't register??? Any ideas plse
|
| SUM Issue.. HELP | 15 Nov 2007 18:49 GMT | 4 |
Need to get a total of a column but the column contains N/A until information it typed then it gives you a number.. i need the numbers to add... ??? Example below 3 $1.46
|
| Currency Custom Format | 15 Nov 2007 18:31 GMT | 2 |
Is it possible to custom format currency in a cell to round to something other than a dollar? Example: $20,865.20 needs to display as $20,9 or $20.9 (including rounding) Is this even possible?
|
| Need help: Excel automatically change input values | 15 Nov 2007 18:13 GMT | 3 |
Excel version: 2003 Symtpoms: Whenever I input 1, excel automatically change it to 00.1. Whenever I paste a value with a comma (",") as a deliminator, excel
|
| Lost File...please help!!! | 15 Nov 2007 17:58 GMT | 2 |
My daughter sent me an excel spreadsheet via email attachment. I opened the attachment and entered a ton of stuff in the spreadsheet. I forgot that I had just accessed the file through the email attachment and when I was finished I just clicked "save" not "save as". Now I ...
|
| Import data from website everyday at certain time... | 15 Nov 2007 17:32 GMT | 2 |
I know how to import data from a website using the webquery but can you set it up so excel imports the data at a certain time of day. For example could I have the webquery import the data at 7:00pm every night? Can I do the same thing using xml import?
|
| how do I add a caption to a picture in Excel | 15 Nov 2007 17:29 GMT | 4 |
I know Word has the ability to caption a picture (insert picture -> right click on picture -> Caption). Does Excel have similar functionality?
|
| QUESTION ABOUT ENTERING DECIMALS | 15 Nov 2007 17:19 GMT | 2 |
Is there a way that when i enter the number 65.26, the cell will change the number to .6526? Thank you!
|
| Date Display | 15 Nov 2007 17:13 GMT | 4 |
How can I configure a cell so that I can enter 11152007 as a date and have it display as 11/15/2007? Thanks, patty
|
| My num pad is locked | 15 Nov 2007 17:12 GMT | 1 |
I have a major problem, when ever I open Excel 07 and press one of the 9 digits in my num pad (desktop keyboard) a messagebox opens "MS Office cannot find the data you are looking for" This mean that I cannot use my numpad at all :(
|
| Pivot Table from Macro | 15 Nov 2007 17:00 GMT | 2 |
I am trying to produce a pivot table using a macro. I have the following: Sub Macro4() '
|
| Filters | 15 Nov 2007 16:49 GMT | 2 |
I am using Auto Filter on a list that is on two pages, the filter works fine, however I want to print the filtered data only and if some of the data is on page two, two pages print out. How do I print only one page of filtered data? Thanks
|