Mac Forum / Applications / Excel / March 2009

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
What formula do I use if B17 is grater than b14 and I want the sum of the two numbers in b19 to show a positive number not a negative but if b17 is less tha b14 i want the sum in b19 to show a negative number?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Apparently, last night, the Excel preference for calculation was switched to Manual, rather than Auto. I didn't purposely do it - in fact, haven't had the preferences open in Excel for months, if ever.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I followed the directions on the discontinued thread for inserting rows and getting the error message about moving objects off the sheet. It still does not work. I have no "objects" on the sheet; I have some ...

I have a number of sheets of data comprising between 1700-2000 lines of
data.
I want to sum the values of one column, where the first 3 characters in the
next column for each value = "abc".

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Hi

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
When I right click, Excel crashes and closes. This seems to affect most but not all spreadsheets. None of the spreadsheets are complex, but most have been created on the PC -- Excel 2000; they are in XLS ...

Surely there is a simple solution for this, but my macro skills are
getting rusty.
Trying to open a Word document via an Excel macro. This is on a
Macintosh so the ActiveX solutions I have seen do not work. The Word

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I just want excel to show exactly what I type, be it a number, or a date. But somehow it keeps changing stuff for me and it is driving me nuts! For example, I type in 01/09 and I want it to show exactly that, ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I am attempting to migrate functionality from VBA to Applescript. I have created my first Applescript macro and can run it from ScriptEditor. I can also make it show up in the AppleScript menu when I am running ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I'm creating a simple excel spreadsheet and I am wondering how I create a drop down menu in one cell? I'd like to be able to choose from about 20 different cities in this drop down box. Thanks for your help.

I have a workbook with multiple VBA forms that I created on Excel 2003 for
Windows.  I'm in the process of making the workbook available on a mac
computer with Excel 2008.  Much of the process is trial and error to get
certain functions working which are not available with the ...

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
I have been using Excel for months without problem but today when I tried to open it to create a new work book it quits immediately when I try to do anything after opening it.

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have an excel workbook. I open it. Excel ask if I want to save, but did not change anything at all. just opened it. why?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I have set the GoalSeek symbol into my format list--it worked. A day later I tried to move it to another menu and lost it somewhere.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
In Excel for windows when you are in a cell you can create a soft return to start another line within the cell by pressing Alt+return. This does not work in Excel:Mac 2008. Can anyone tell me how to create a ...