Mac Forum / Applications / Excel / March 2008

We work with Windows and Mac and Windows SBS 2003.
If I open a file in old xls format of the network, and i save the file, Excel show an error message.
I cannot save the file once more, again an error message.
In the new xlsx format this mistake does not appear.

I have my iMac set to stop font smoothing below 10pt. Excel 2008 seems to ignore this setting and I can find no way of changing this. The result is that speadsheets with fonts of 10pt look as though the ink has run! I am using Arial by the way. Can anyone shed any light on this?

I have been using MS Excel for many years and still do at work. I regularly use "Array Calculations" and sometimes use Macros written in Visual Basic. Neither of these capabilities are available in Numbers. I also understand that Visual Basic is unavailable in MS Office for Mac ...

I want to produce mailing labels in Word, using an Excel spreadsheet as a data source. I want to reduce the number of records by having unique values in the MAddress field; that is, I want to mail to a family (residence) rather than to individuals (e.g. spouses who reside at the ...

Apologies if this question has already been asked. If so please point me in the appropriate direction.
I have hundreds of spreadsheets where the column widths are being quoted differently depending on whether I open them with Mac Excel 2004 or Mac Excel 2008.
For example, a column ...

In working with rows of data in Excel, I often need to move them to the bottom of the page. This is something that I repeat often as I'm finished with that row and want to get it out of the way but not delete it.
SO...is there a way to set up a Macro/Button to do this, greying out ...

Hope someone can help, I'm trying to set up a database in Excel for Job Resumes (I am a Recruitment Consultant). can someone help with a template or any suggestions?

Ok, for some of us tools such as solver were essential.
Can something be done?
Is there any realistic way to get something out of Microsoft ?
Can we get a refund and trash Excel - along with the entire Office 2008?

I am using Office 2008 (v12 build 071130), Leopard 10.5.2, on a Macbook Pro. What I am finding is that every time I enter text (or any info) into a cell, the cell automatically accepts the data and returns the cell to the normal state. Thus if I am typing a sentence, I will end ...

I was customizing the toolbars in Excel (Office 2008) and could not find the Print Preview icon to place on the toolbar.
Is it gone in this version?

I was rather hoping that 2008 would catch up with the Window version - and enable sheet tabs to be individually colour coded, but no. I suspect there is a technical reason which, as a programming/code/techno novice, I wouldn't understand - but (a) is there a fix out there somewhere

I've been working with PMT and other functions for calculating a loan.
In my case, the loan has a fixed term and fixed interest rate.
Does anyone know how to factor in pre-payments?
thanks.

When I enter the year 2007 in cell it shows as 20.07. How do I
set formula so that decimal point does not enter number?

Hi Molly -
Take a look in Excel> Preferences> Edit & clear the check on "Display this
number of decimal places:".
HTH |:>)

can anyone indicate the character used to insert a carriage return within a same cell in Excel.