Applications :: Office For MAC Excel - Dates Change By Plus / Minus 4 Years
Oct 14, 2010
I 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.
View 3 Replies
ADVERTISEMENT
Oct 28, 2010
I looked and I didn't find any info so I just wanted to tell you that Solver for Excel Mac 2011 is now available as a free download here:
http://www.solver.com/
This guys also have some other really cool tools if you want to check them out.
View 3 Replies
View Related
Jan 10, 2009
Does anyone know how to set the Excel (2008 version) toolbars at top of app to remain as a saved preference? I've tried everything and when I quit Excel and re-open, everything I've changed about the toolbar view is gone and I'm left with nothing. It wasn't like this all along, and somehow I ended up this way.
View 17 Replies
View Related
May 13, 2008
Does 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 Related
Oct 26, 2010
Does anybody know where the controls / forms toolboxes are. Just got to the end of building a spreadsheet, and cannot find the control toolbox anywhere for adding spinners, check boxes etc. Is it even included anymore, as web searches draw a total blank for me.
View 1 Replies
View Related
Apr 17, 2012
At the moment I do not have Microsoft Office for my mac but I am looking into it as I will be going back to study soon and know I will encounter problems when it comes to transfering documents from my mac to a PC with Microsoft software. However I really love the mac application 'Pages' for personal projects so I am just wondering if I can still use it alongside Microsoft or I must give it up?
Info:
MacBook Air
View 8 Replies
View Related
Aug 23, 2014
I would like to be able to sort them by the date I think they were taken, so I need to change the dates of the files to specific dates. I want to be able to do groups at a time. Like all photos taken on a birthday, and for pictures I do not know the date for, dated to the date the person in them died.
When I click on a group of photos Aperture changes the dates in a relative fashion rather than an absolute fashion. IE If I scanned the images that were taken on the same day but were scanned 2 months apart, the date that appears on one is correct, the other 2 months off. I would like to change the dates to specific day in time.
Info:
Aperture 2, OS X Mountain Lion (10.8.2), with aperture 3 upgrade disk
View 10 Replies
View Related
Jun 8, 2012
I just copied a very large number of files using Finder and I discovered that some modification dates were changed. For me this wasn't a problem, but it's strange and I don't understand why it happened. I wonder if anyone else has seen a similar behavior. Here are the details:
I have a Mac Pro running under OSX 10.7.4 with 15 GB of RAM and 7 hard disks. The disks details are as follows: Internal 1 is 500 GB and came with the computer. It is my boot drive and has a variety of material. It's about 75% full.
Internal 2 is 1 TB. It has OSX 10.6.8 on it for use as a repair disk if I need to run TechTools against my main drive or if I need to run SpringCleaning. It is about 85% full and contains mainly videos of one type or another.
Internal 3 is 2 TB. It is 98% full and contains mostly .jpg files. This drive has a single root folder with 3-4 levels of subfolders. Some subfolders have as many as 5000 folders in them. The bottom level folders each have anywhere from 20 to 300 files.
Internal 4 is 3 TB. It was purchased last week because drives 2 and 3 are getting full. My intent is to copy drive 3 to 4, then copy the data from 2 to 3. I'll probably retire 2 since my SMART checks are showing problems.
External 1 is 3 TB and is used only for Time Machine to backup internal 1.
External 2 is 4 TB and is used to backup Internal 2 and 3 using ChronoSync. I'll be changing this to 3 and 4 soon.
4 days ago I installed drive 4 and used Finder to copy the root folder from drive 3 to 4. That took about a day. I then ran ChronoSync in Trial Sync mode to see if everything was OK. (Perhaps I shold have used ChronSync to make the transfer.) I discovered that about 8,000 files had discrepancies. I wrote a simple AppleScript to identify any meta data differences between the files on the two drives. It's been running for about 12 hours and I suspect it will take more than a day to finish. So far all that script has found are modification date differences. I've examined about a dozen of the files and they look OK.
Anyone seen anything like this? Any ideas what happened? I have three user accounts on this Mac Pro. The copy was made in one account with nothing else running, but I was doing a variety of work in another account. The third account was not active. I just did a better search of this forum and discovered a similar case from 2010.
View 1 Replies
View Related
Jul 30, 2010
How do I change the decimal separator from a comma to a dot in Excel 2008?
View 6 Replies
View Related
Dec 15, 2009
I'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!
View 3 Replies
View Related
Jan 31, 2008
Do 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
Nov 30, 2010
I recently downloaded and installed Office for mac 2011. Unfortunately, i had already had a different version of office for mac that contained a different name (my friend's) who had licensed the product and registered for it. Now that i paid and have office for mac 2011, i'd like the product to be installed, licensed and registered under my name. unfortunately, i don't know how to change the name that says it's still registered to, when it should be registered to me now.
View 6 Replies
View Related
Mar 31, 2010
I am writing a legal brief, and I need to have different numbering systems for each section of my brief, but I can't figure out how to do it in Office 2008. One for the cover page, roman for the table, and arabic for the rest.
View 3 Replies
View Related
Jun 9, 2012
has anyone had an issue with office mac 2011 excel and osx lion? i make excel spreadsheets with pdf storyboards on them, and too often the excel file will not reopen. instead i get a corrupt file notice. i choose fix file and the file opens without the pdf files. sounds like a pdf/excel issue to me. it is maddening.
Info:
Mac OS X (10.7.4)
View 6 Replies
View Related
Aug 11, 2009
How do I do it? I want the document to require a password to open. I did the tools-->protection--protect workbook/sheet thing but that didn't do it, the document could still be opened, just not edited. I have a budget sheet with all of my online account passwords I don't want accessible if the computer gets stolen.
View 3 Replies
View Related
Jun 5, 2014
I need to add MS Office Excel and Word to my laptop, which one should i purchase. There are many choices.
Info:
MacBook Pro (13-inch Early 2011), OS X Mavericks (10.9.3)
View 2 Replies
View Related
Nov 15, 2007
The planned mid-January release of Office 2008 offers a significant overhaul of the productivity suite's look and features.
The previous segment described new features in Word 2008, with some comparisons to Apple's Pages 08. This article examines what's new in Excel 2008 and contrasts Microsoft's oldest application to Apple's newest: the Numbers 08 spreadsheet included with iWork.
View 25 Replies
View Related
Oct 27, 2010
I've seen conflicting information about the new Office Mac release. Have Macros been restored to Excel? And if so, what language are they using? Has anyone tried them or tried to import Macros from Excel 4 or Excel 5 macro languages?
View 3 Replies
View Related
Oct 28, 2010
I was previously using Excel with no problems, then installed updates Tuesday, now can't open .xls file last used Monday?
View 2 Replies
View Related
Mar 25, 2012
After latest Apple software update (3/24/12), Office for Mac crashes when trying to open Excel or Word.
Info:
iMac7.1 24, Mac OS X (10.5.1)
View 3 Replies
View Related
May 21, 2012
How can I resize my spreadsheet so that it fits in the office for Mac excel spreadsheet when opening an existing windows file? Last column goes to another page.
Info:
MacBook Air, Mac OS X (10.7.4)
View 1 Replies
View Related
Feb 7, 2012
After upgrading to Lion, I can no longer see the text in my word documents or excel worksheets. I know the text is there because it appears in the formula bar - it just isn't visible in the cells. I can also see the text if I quickview the excel files. In the word documents, all I can see are the pictures/images...no text. Weird. I have the latest version of Office 2008 and Lion OS.
View 2 Replies
View Related
May 16, 2012
Other products in suite work - Word, Powerpoint but excel wont open any files. The error condition is:
Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2012-05-16 21:53:44 +1000
Application Name: Microsoft Excel
[code]....
Info:
iMac, iOS 5.1.1
View 3 Replies
View Related
Feb 6, 2009
I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.
It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.
What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.
Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?
View 6 Replies
View Related
Apr 13, 2010
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
View 1 Replies
View Related
Sep 1, 2009
I have MS Office 2008 for Mac installed and have no use for the other apps, but would like, to have my Mac clean and the ~ 1GB of hdd space more. Is there a solution, to uninstall ALL MS software except Excel? Unfortunately, Excel still is a few nose lengths ahead of numbers.app, which neglects some functions and the sheer speed of Excel.
View 2 Replies
View Related
Feb 20, 2008
I'm doing a paper in Office 2008, and need some charts for better visualization. I want to have some graphs showing the numbers of listeners of ten different radio stations by columns.
To provide good labeling I thought about the names of the radio stations under the chart, but horizontally it's quite a mess, vertically is hard to read. So is it possible to orientate the labels diagonally, maybe sixty degrees or see instead of the pre formatted settings of 270 degrees? I couldn't find definite answers via Excel help or even Google. ("excel chart labels orientation").
View 1 Replies
View Related
Dec 1, 2010
Two strange issues that I can't fix on my new MB Air 13 with MS Office for MAC 2011 and Excel.
1) I can't get the Standard Toolbar to show up when I open a new worksheet. I go to view, toolbars and then see that the Standard Toolbar is checked, but it doesn't show up. The only way to get it to show up is to do a series of steps:
- uncheck Standard Toolbar menu and go back out;
- go back in and check the Standard Toolbar and back to the spreadsheet
- the Standard Toolbar still doesn't show up;
- so then I click on the Layout tab on the ribbon and then it shows up!
2) I can't see the bottom of the window/spreadsheet - which means I can't resize the window. To resolve this, I have to do these steps:
- open system preferences and change my MBA screen resolution from 1440 x 900 down to 1280 x 800
- then go back to the spreadsheet, and resize the window (make it smaller on the screen)
- go back and resize the window back to 1440 x 900
- and then close the system preferences at this point, the Excel spreadsheet window is smaller and I can see/use the bottom of the screen to resize, etc.
Can't figure out what setting I have wrong or why I can't get Excel for Mac 2011 to work correctly on the MB Air screen.
View 5 Replies
View Related
Mar 28, 2012
When i try to open a specific file in excel or word, very often a number of other recently used documents open up too!All documents were saved prior to closing at last use. Does anyone know how i stop multiple documents from opening up?iMac mid 2011,Office:mac 2011 "WPX" Home and Student all have up to date software?
Info:
iMac (21.5-inch Mid 2011), Mac OS X (10.7.3)
View 1 Replies
View Related
Jun 5, 2012
When i try to open a specific file in excel or word, very often a number of other recently used documents open up too!
All documents were saved prior to closing at last use. Does anyone know how i stop multiple documents from opening up?
iMac mid 2011 Office:mac 2011 "WPX" Home and Student all have up to date software
Info:
iMac (21.5-inch Mid 2011), Mac OS X (10.7.3)
View 4 Replies
View Related
