Mac Forum / Applications / Excel / July 2008

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Instead of typing the full year,i.e. 2008, I try '08 and get an error smart button. None of the options allow this result.

Version: 2008
I need to create an invoice template, where in column B I enter the product code, and then in column C the product description should automatically appear. I have successfully done this using one product description:
=IF(B14="H12co","Hearts 12 pack Coast")
However ...

I just created my post with details and the site crashed so I am going to try
a Cliff Note Version.
Client - Excel File (3+MB) - used successfully on SBS 2003 network on the
SharePoint Site with minor difficulties getting it to save properly.

I want to prevent entry into a cell, O3 unless another cell E3 has
something in it.
The validation I entered in O3 is  =ISNONTEXT(E3)  but when I check
validation later I see:   =ISNONTEXT(E3)e

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Hallo!

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I'm having trouble doing simple functions such as the average and sum functions with numbers that begin with a zero such as 0.09867, 0.09786.... I know that there must be a simple solution to this error but I'm ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
Why is the text not appearing as I type into a cell - only to suddenly appear after I press return?

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
I exported entourage files to a txt document. I then opened in Excel and saved as a csv file. When I try to merge for mailing labels I get the error message that a record does not have the same number of fields as the first ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I think it's the lack of an Interactive PRINT PREVIEW that has me stumbling around, more than the lack of View->Page Break Preview.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I was wondering, I am new to Mac, how do i change the color of the tabs at the bottom of the excel spreadsheet, the ones that change from sheet to sheet.

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
I have a spreadsheet where I would prefer the rows to be columns and the columns to be rows. This would help me extract data using a comma-delimited format.

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
When plotting a data table in a graph, numbers appear with no decimals even if they are written with one decimal in the source. If i want to give format to the data table, the tab "number" does not appear...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
With my PC I can link to Microsoft Excel spreadsheets etc online and download them. I have been unable to find a mortg or loan amort schedule to use with the Mac Excel. Can someone direct me?

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

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
the sum of a column of numbers (in the format [h]:mm) is greater than the combined sums of =SUMIF calculations where all the cells are accounted for. There are no rows hidden that could be contributing to the incorrect sum. ...