Mac Forum / Applications / Excel / February 2008

Just installed office for mac 2004, now on my second spread sheet excel will not let me insert rows, why is this?

Is there anyway to prevent Excel from removing the leading zeros from a zip code when I export a file from my database into a .csv file? We frequently export data into Excel, but I end up having to retype in hundreds of "0" at the beginning of zip codes. Any help would be greatly ...

When zooming in on sheets with cells in accounting format, numbers will appear as ###### ################### regardless of column width. Values appear correctly in the formula bar, but not on the sheet. This occurs at zoom settings of 121 - 125%. Other zoom settings display values

Hi I just need to know if there's a way to enter " 2 / 59" without it changing to a date.
I'm trying to enter fractions but It keeps switching to dates.
Thanks.

I haven't used Excel in a long time and I was wondering if there is anyway to get the outlines of the cells to print. When I print the document, it takes away the column and row outline and I want them to appear on my printed page. Does this make sense?

Can I remove the toolbar?

I'm trying to take a pie chart created in Excel into another program to go to print and need a higher resolution than 72dpi. In the past, I've used it as a template and recreated it in Photoshop, but does anyone know a way to just get a 300dpi output so I don't have to recreate?

Anyone know why I get a new window approx 150 px below the menubar on every new window launch?
See link: <http://img81.imageshack.us/my.php?image=picture6za7.png>
I've tried resetting prefs to no avail. Any suggestions?
Thanks!

I've just installed Ms office 2008 and now when I type letters,all of my numbers come out as letters almost like roman numerals. This is happening in Imail , Word, and Exel. The funny thing is that it does not happen to all of the documents, some of them it actually works ...

I am unable to locate the active cell, in windows it was highlighted in black, in mac it is a light blue and virtually impossible to find, causing errors and lost time and productivity. I searched help and menus to no avail, please help me change the appearance of active cells to ...

I want to make lettering to down the side, with numbers at the top.
I also want to make the boxes square (equal length and width for each box so the rows have the same space as the columns)
thanks!

I like my worksheets at 150%, in normal view, and without page break lines. Excel thinks it is best for me to have them at 100% and in page view. Converting them takes three steps - change to normal view, change to 150%, and go to preferences and remove page breaks.
My standard ...

I have recently tried to use Combo Boxes to make drop down lists. It seems to be working great, except for the fact that the info I have in there is really long. Is there any way to increase the height of the boxes or allow the text to be "wrapped" to two lines. I have tried ...

Can anyone enlighten me on the fundamental difference why the same VBA
code runs at such different speeds on Macs vs. PCs?
Here's an example. I wrote some code months ago on my PC at work (Dell
1.73GHz/504 mB RAM/Windows XP). The task involved transposing 4000+

I am having strange problems with XIRR in a spreadsheet in Mac Excel 2004 (11.3.7). I can enter the formuala fine in using =XIRR(values,dates) and it returns an answer. However when I recalc, I get a #Value! error. I went to similar spreadsheets that used XIRR and hit recalc, and ...