| Thread | Last Post | Replies |
|
| Excel accounting format | 05 Oct 2006 02:47 GMT | 3 |
I have an entire column formatted to accounting. But, when I type in a certain amount - $50.47 it changes that to display "14 Marena St47" . What is this- even when i change that cell to 'text' format, it still always displays this 14 marena st47. It does the same for currencyI ...
|
| Excel Date reads the days as the year. Whats wrong? | 05 Oct 2006 02:26 GMT | 1 |
For some strange reason, when i type in the date to be automatically formatted in the chosen format (mmm dd/yyyy) the output puts the day as the last 2 digits of the year and the day is always the first of the month - ie "sept 28" reads Sep 1/2028. What is wrong here?
|
| How to look up a value in a list and return multiple matches? | 04 Oct 2006 19:29 GMT | 1 |
I viewed a posting on the power users corner of microsoft and it explained how to retreive multiple matches from a value list. I keep getting a #value error. Could some one help me resolve this error or give me another way to retreive mulitple matched values from a list. The name ...
|
| Microsoft Needs to Fix this Serious Problem with the Technical Ref | 03 Oct 2006 15:51 GMT | 1 |
I had been running the Beta 2 of Office no problem. When I installed the Technical Refresh, I now have a problem where Excel will not open any Excel files. Each time I get a dialogue box indicating that Excel can't open the doc b/c my virus software is not up-to-date or b/c there is ...
|
| in-cell drop-down arrow button disappeared | 03 Oct 2006 15:42 GMT | 2 |
i have data validation lists in many cells (a whole column of cells with the same list) and for some reason, when i select one of these cells, the drop-down arrow button no longer appears. i don't know how this happened, but it is very annoying to have to right click and select ...
|