Applications :: How To Change Excel 2008 Decimal Separator
Jul 30, 2010How do I change the decimal separator from a comma to a dot in Excel 2008?
View 6 Replies
ADVERTISEMENT
Applications :: Using Excel 2008 - Colors Change From Windows To Mac And Back
Dec 15, 2009I'm trying to use my MacBook more and more at work but have run into a slight problem with Excel 2008 (all the updates are installed).
When I open a Spreadsheet that was made in Excel 2003 on windows that has some cells colored in, make any change then save, all the colors that the cells are shaded change. They originally are bright colors and after saving on my Mac they've changed to muddy, dark versions.
As these sheets are used by multiple people this has made me quite unpopular in the office!
Software :: MS Excel Decimal Place Holder
May 22, 2006Do you know how I can change the format for the decimal place-holder in MS-Excel? Presently, the place-holder is a comma (,) -- this is extremely inconvenient when trying to work with data sets in multiple applications (all the others use a period). How can I change the decimal place holder to a period (.)?
View 7 Replies View RelatedApplications :: No Add Ins In Excel 2008?
Jan 21, 2008There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.
View 12 Replies View RelatedApplications :: Excel For Mac 2008 Crashing
Jan 4, 2010I'm having a problem where whenever I change a particular cell in a relatively complex spreadsheet I built, Excel crashes. The cell is a trigger cell that changes a list of assumptions to calculate a particular scenario. The spreadsheet was working fine and then, all of sudden, this problem arose. I had this same problem about 3 weeks ago and ended up copying individual tabs into a new spreadsheet and globally replacing the links so it was working. That worked okay until this most recent incident. The stranger thing is it seems I can open the spreadsheet using Excel for Windows and it doesn't crash.
View 8 Replies View RelatedApplications :: Mac Excel 2008 - Vlookup
Jun 17, 2010One of my favorite functions doesn't work - really weird. When I get to line 50 of the workbook it stops working! It doesn't matter if I cut n paste, drag or manually input the formulae it just stops ! Every row above row 50 - it works - below 50 ... nope #value appears. So an argument is wrong - but I'm inserting the same argument that works above !!!!
Is this an Mac Office glitch or am I losing my mind
Any advice appreciated . . . Stu
edit: just realised that if I increase the lookup to row 75 the reference works up to row 75 but not beyond - weird. I can't replicate the problem on MS Office on a pc !
Applications :: Insert Calendar In Excel For Mac 2008
Sep 24, 2010I have been trying to insert a simple monthly calendar into an excel spreadsheet, but cant find a way to do this on the mac version that im running. Any hints would be great. Idealy i would like to be able to just insert a calendar for that month but if i had to insert the whole calendar each time that would be fine too
View 2 Replies View RelatedApplications :: Lost Data In Excel 2008
Dec 6, 2010Some content in Name.xls may not be saved because it is not compatible with the Excel 97-2004 Workbook (.xls) file format. Do you still want to save the workbook in this format? To save the workbook in a new format and preserve all content, click No, and then on the Format pop-up menu, click Excel Workbook (.xlsx). To save the workbook in the current format and remove all incompatible content, click Yes." Somehow I managed to not read the popup properly and just went ahead and saved (clicked "yes"). I then closed the spreadsheet and now all the work from the past 4 hours is gone.
View 2 Replies View RelatedApplications :: Excel Mac 2008 Macros Support
Jan 28, 2008I know Excel 2008 does not support VB macros, but did anyone notice that "Macros..." is still available under the Tools menu? I wonder why it's there? BTW, I saved an old file in Excel 2008 that had macros and then opened it in Excel 2004 to see if the macros are still there. They are. That's a big relief, because I know I can at least work on files that have VB code in them without worrying that if I save the file in Excel 2008 format the macros will go poof. Ooof
View 8 Replies View RelatedApplications :: Excel 2008 Crashes On Saving
Feb 1, 2008Is anyone else getting this problem? When I hit Command+S in a worksheet, Excel unexpectedly quits. Very frustrating as backing up is kind of a problem.
View 3 Replies View RelatedApplications :: Making Graph In Excel 2008
Feb 17, 2008I need to make a very, very simple line graph. In column A, I have a list of years. In column B, I have the data....numbers that correspond to something in that year. Simple, right? It really couldn't be any less complex. I selected both columns, then I went to create a new line graph, and it created a graph that had the years (from 0-2500 even though the actual range is 1973-2005) on the Y axis, and the data on the X axis. And each column of data was its own series, so I had 2 lines, which, due to the scales, was basically 2 horizontal lines. I removed the extra series (the year series), and was able to get the line to look right. It also put the column B data on the Y axis like I want, but on the X axis, it just counts from 1-33. But I want the years on the X axis. How the hell do I do this? I'm 99% positive Excel 2004 let you set the X axis labels.....did they really remove it in 2008? This seems like something that should be so simple, I shouldn't have to post on a forum to figure out
View 24 Replies View RelatedApplications :: Excel 2008 Date Formula ?
Feb 28, 2009I have a very limited knowledge of Excel, but generally find that I can figure things out eventually. However, this time, I just can't seem to tweek it so the result is what I want.
I have a spreadsheet for tracking parts ordered, and simply need to display how many days a part has been on order. I have a column for date ordered, and one for date received. Is there a way to program the formula to tell me the days that a part has been on order without displaying today's date in the spreadsheet (leaving it blank), and still be able to enter the date that it does arrive for our records?
Applications :: Excel 2008 For Mac Save Dialogue Box Too Big
Nov 7, 2009New to Mac and new to Office 2008. When i try to save an excel file once I click the little upside down triangle to choose where the file should save to the dialogue box which opens is larger than the screen with the save box to the right of the screen. How do i resize this so that I can see, and use, the whole dialogue box?
View 9 Replies View RelatedApplications :: Excel For Mac 2008 / Finding Data
Dec 30, 2009In my old old old excel 2003 when I was searching for some words in excel sheet (e.g. in the column) I could choose "to find all" option. So I saw all the results in the "find" window. In excel 2008 for Mac I can see search results only one by one not altogether. On microsoft site http://www.microsoft.com/mac/help.ms...f-17820d214cef
I couldn't find tha answer also. Does anyone know how to make it in excel 2008 for mac so i could see all search results in the "find" window?
Applications :: Data Analysis In Excel 2008 In Mac?
Jan 7, 2010How do I get data analysis in excel 2008 in mac?
View 3 Replies View RelatedApplications :: Excel 2008 Error Message?
May 21, 2010This might be the weirdest software bug I've ever seen. It looks like maybe a programmer for Microsoft was having some fun. Here is what happens:
A spreadsheet that a coworker uses for purchase order requests has several cells in a column with a SUM field that calculates the number of units to purchase multiplied by the unit price (not sure why they use SUM for just a multiplication, but I don't know if that matters).
If you delete the contents of one of these cells and type in something else (or just type something else without deleting first), then exit the cell, an error message pops up that says, "You can't do that!!!!! So quit trying!!!" with options Cancel and Retry.
Retry doesn't do anything, Cancel clears what you put in the cell. Copying and pasting the cells into a different row creates the same issue.
I've attached several screen shots to show steps to reproduce:
Picture 1 - column F has the suspicious cells
Picture 2 - the calculation
Picture 3 - after deleting the contents
Picture 4 - enter some text, before exiting the cell
Picture 5 - error message after exiting the cell
The only workaround was deleting the entire row and entering those calculations again. I have no idea what to make of this, and internet searches have come up empty.
Applications :: Excel 2008 - Reset Formula Bar Position?
Mar 19, 2008The left edge of my excel formula bar is not showing-almost as if it was pushed off the left side of the desktop (see picture). Unfortunately, the only part of the formula bar that allows it to move is now hidden, so I can no longer move the formula bar. I have tried switching the formula bar on and of in "View" and also tried re-loading excel, but it is stuck. Does anybody know how to reset the formula bar position?
View 6 Replies View RelatedApplications :: Excel 2008 Extremely Slow At Plotting
May 20, 2008I'm trying to use Excel 2008 (I wish I still had my old 2004 CD with me) to do some plotting and it's near impossible. I'm plotting spectrum data off of an optical spectrum analyzer, so we're talking some 3000 data points. I select the data, create a chart (annoying as hell in itself) and once the chart shows up I can't do anything without at least a 10-20second wait, I can't select an axis, move the chart, rename it or anything. Why is this so slow and is there anything I can do to speed things up? Doing such plotting using an old school Excel on an old computer running Windows 2000 was no problem at all.
View 7 Replies View RelatedApplications :: Excel 2008 Opens Blank Sheets
Jul 10, 2008Has anyone else experienced this problem with Excel 2008 after installing SP1? Attempting to open any existing spreadsheet fails, with Excel just opening a blank sheet instead. Microsoft were "aware of a problem" with SP1 which they claimed to have fixed with update 12.1.1, but as per usual and what we should perhaps expect with Microsoft, the "fix" makes no difference whatsoever, and I still can't open any of my existing spreadsheets! Their "workaround" also has no effect. I am running an Intel Mac with OS X 10.5.4 and Office 2008 12.1.1
View 3 Replies View RelatedApplications :: Excel 2008 Substantial Calculation Errors
Sep 8, 2008Has anyone noticed substantial calculation errors in EXCEL 2008 - specifically, the XIRR and XNPV function? I ran a cash-flow series and then ran both the XNPV and XIRR function. Then i used an alternative calculation methodology, using the SUMPRODUCT and Goal Seek functions, to calculation the NPV and IRR of the same series of monthly cash flows (note that these alternative calculation methodologies are used to produce the same incremental calculations that are supposed to be rolled up into the XNPV and XIRR functions).
Results: The XNPV is off by 1.26% and XIRR is off 26.77%. I guess that isnt to bad when considering the investment of millions of $. XNPV would only cost me $126,000 on the million. So much for Gold Standard of financial analysis. Whatever happened to Lotus 1-2-3? It might be archaic but at least it generated proper answers.
Applications :: Excel 2008 - Major Gridlines For Charts
Apr 22, 2010Is there a way to individually select which tick marks receive a major gridline? As far as I can tell, the only options are to have all tick marks with a gridline or none. For example, in the image I attached, I want the horizontal axis to cross at -0.5, and I want a gridline at 0, but I don't want gridlines from any of the other vertical ticks. Thanks for any help you can give.
View 2 Replies View RelatedApplications :: Delete Duplicate Cells In Excel 2008?
Jul 19, 2010does anyone know how to delete duplicate cells in Excel 2008 for mac?
View 3 Replies View RelatedMacBook :: Lost Program Icons Are Word 2008 And Excel 2008
Feb 8, 2012I accidentally trashed two of my icons on my icon bar I didn't put them in the trash but when I clicked them they turned into wads of trash. I don't know how to find them now?
Info:
MacBook, Mac OS X (10.5.8)
Applications :: Excel Graph In Office 2008 - How To Label Axis
May 13, 2008Does anyone know if you can label axis in excel 2008? I know before SP1 it couldnt be done, just wondering if anyone has come across this in the to SP1? Or it can be done already? Because its pretty useless for me without that feature!
View 4 Replies View RelatedApplications :: Quitting Word / Excel 2008 Takes Forever
May 24, 2009My Office 2008 apps (Word / Excel) take forever to quit. When I quit the app, the documents are closed quickly, but then the app stays around for a minute or so, unresponsive, enough to cancel a logout. If I quit the app and wait long enough, it finally quits.
View 3 Replies View RelatedApplications :: Copy Paste From Excel 2008 To Adobe Illustrator
Dec 23, 2009I'm struggling already whole with trying to copy and paste a excel diagram from excel 2008 to adobe illustrator CS3. Now I found out on the microsoft homepage, that this is a known problem and also in several forums people where struggling with this. Microsoft suggests to copy something from illustrator into excel and afterwards it should also work the other way around. This is definitely not the case. I really need to solve this issue. Does somebody know if there is another solution, or to whom one could contact, or if a update which could solve this problem is in the pipeline?
View 2 Replies View RelatedApplications :: How To Add A Separator To Safari Bookmark MENU
Nov 15, 2009I do have Glims installed and I checked "Replace bookmark titled "-" with menu separator." However, I can't get it to work.
What exactly do I need to do? I tried adding a folder to bookmarks menu by clicking "+" and then renaming the folder to "-", but it didn't work. I also tried renaming a bookmark to "-" or - if you will, but nothing worked.
Applications :: Excel 2008 - How To Create Pie Chart With Black And White Styles
Oct 5, 2009Can anyone tell me how to make a pie chart in Excel 2008 that uses different styles of black and white cross hatching for each slice. Its carefully hidden in Excel 2007 as a custom style, but I can't find a way of doing it in Excel 2008.
View 2 Replies View RelatedApplications :: Office For MAC Excel - Dates Change By Plus / Minus 4 Years
Oct 14, 2010I have office loaded on my Mac. I work with a variety of spreadsheets and different applications like Open Office, Access, Excel. Most of my data comes from applications on the PC side. When using Office for Mac, I open a new Excel spread sheet and copy and paste data from one of the other applications. So I have a column of dates in Open Office, I copy the date column and paste into Office for Mac Excel.
When I do this the dates change by plus or minus 4 years. So if I move data labeled 10/8/2010 when I paste it into Office for Mac Excel I get 10/8/2014 or 10/8/2006. Sometimes I even get a different month or day along with the plus or minus 4 years on the year. When I move the data into Office for PC Excel I don't have the problem. The dates copy over just fine. I am not using date formulas or functions. It is simply dates put into the column that I am trying to copy into a single spreadsheet.
Applications :: How To Change Product Key (Office 2008)
Jan 31, 2008Do anyone know where the productkey file for MS office 2008 is located or if I, in some way, can change my product key in this program?
View 24 Replies View Related