Mac Forum / Applications / Excel / November 2006

I am receiving a strange error message when trying to apply cell formatting
to multiple cells in a row.  Goes like this:
Select a1::a4
FORMAT>CELLS

I'm creating a worksheet to record activities at different times of the
day.
I want to record the duration of the activity
The easy way to do this would seem to be to record the start time and

I just ran across this announcement on Microsoft's Mactopia site):
Note: Visual Basic for Applications (VBA) will not be supported in the
next version of Office for Mac, currently code named ³Office 12.²
Independent Software Vendors (ISVs) who currently use VBA for scripting

I wish to create a series of DROP DOWN MENUS to input data into a spreadsheet.
ie. TV's (not the best example really).
In the first drop down box, I wish for the MAKES of TV to appear. ie, SONY
TOSHIBA, PHILIPS etc,

Can you network a Mac and a PC to copy an Excel file from the Mac to
the PC and have that file function properly in Excel on the PC?

Is there a way to print a row along the top of each page, with the
exception of the first page?
Specifically, I would like my repeating row to begin on the third page.
Thank-you.

Hi (please forgive a noobie -- I'm just learning this posting business)
Hi
I have a 2-column table, the result of doing a Insert -> Name ->
Past -> Paste List:

I have data in 2 columns,
If there are X's in a cells in Coulmn 1, how do I count the number of cells
on the same lines as the X's in colum 2 that have a specified criteria?

I am trying to write a formula for this:  If cell b1 can be any $ amount and
cell c1 can be "quarterly", "monthly", semi-annual, yearly, or bi-monthly.  I
want my result to be if b1 is =<100 and c1="quarterly", b1 otherwise b1/4, or
if b1=<100 and c1="monthly", b1 otherwise b1/12 ...

Dates ??
If date in column b1=mar-07, (which by the way looks like 03-07-2007 on the
command line, even if i format it to mar-07. but looks ok in the cell)  so if
date in column b1 is less than a certain date, say, (Mar-08), then type

This sounds like a very stupid question- but I've tried several thing
and can't find the solution; this is very basic but it will have a hug
effect on my performance.
I'm using a new Intel Macbook with OSX and Office. On Excel, for th

I am trying to import my contacts list from MS Entourage on a Mac
running OSX to ACT! on a Dell running Windows XP.
We tried exporting the contact list from Entourage, but ACT! does not
recognize the file format for the list.

Using Excel 2000, when our truck drivers fill in time sheets for when they
deliver loads, they use 24 hour time, such as "1715" (without a colon).  I
would like to enter that number in a column and have Excel convert "1715",
for example, into "5:15PM".  can this be done without ...

We have an ERP application ( SAP) that creates an Excel spread sheet
with HTML tags ( Office HTML). These tags are similar to the ones that
excel creates when you save spread sheet as HTML.
The spreadhseet has header, footer and page setup info like

At the end of my Applescript, I have a line to save as CSV.
    save workbook as active workbook filename "finish.csv" file format CSV
file format
When I try to open up "finish.csv" in a text editor, it gives me a