 |
MSGROUPS.NET |  Post Question |  About |  Groups |  Contact |
 Register |  Login
|
microsoft public excel misc
(9093)
microsoft public outlook general
(7339)microsoft public excel programming
(6569)microsoft public word docmanagement
(5607)microsoft public excel worksheet functions
(5040)microsoft public access
(4768)microsoft public windowsxp general
(3908)microsoft public windows vista mail
(2978)microsoft public windows vista general
(2805)microsoft public windows live mail desktop
(2724)microsoft public office misc
(2268)microsoft public access queries
(2122)microsoft public powerpoint
(2030)microsoft public greatplains
(2009)microsoft public windows server sbs
(1984)microsoft public dotnet languages csharp
(1964)microsoft public access formscoding
(1932)microsoft public sqlserver programming
(1878)microsoft public mac office entourage
(1868)microsoft public access forms
(1798)microsoft public internetexplorer general
(1706)microsoft public mac office word
(1699)microsoft public access modulesdaovba
(1691)microsoft public outlook calendaring
(1436)microsoft public dotnet framework aspnet
(1381)microsoft public project server
(1356)microsoft public windowsupdate
(1353)microsoft public sqlserver server
(1339)microsoft public project
(1285)microsoft public excel
(1277)microsoft public access reports
(1249)microsoft public windowsxp help and support
(1204)microsoft public exchange admin
(1185)microsoft public windowsmedia player
(1165)microsoft public mac office excel
(1160)microsoft public windows server general
(1100)microsoft public dataprotectionmanager
(1096)microsoft public outlook
(1035)microsoft public word vba general
(1029)microsoft public vb general discussion
(1012)microsoft public outlook contacts
(953)microsoft public windows server active directory
(930)microsoft public development device drivers
(923)microsoft public dotnet languages vb
(843)microsoft public outlook installation
(820)microsoft public word newusers
(808)microsoft public word pagelayout
(783)microsoft public windowsce platbuilder
(757)microsoft public excel charting
(733)microsoft public publisher
(728)microsoft public excel newusers
(711)microsoft public windows powershell
(697)microsoft public pos
(660)microsoft public vc mfc
(651)microsoft public access gettingstarted
(630)microsoft public word application errors
(629)microsoft public sharepoint general
(604)microsoft public office setup
(584)microsoft public onenote
(556)microsoft public sqlserver reportingsvcs
(550)microsoft public outlookexpress general
(539)microsoft public scripting vbscript
(533)microsoft public frontpage client
(532)microsoft public access tablesdbdesign
(529)microsoft public windows 64bit general
(516)microsoft public outlook program vba
(502)microsoft public windows live messenger
(434)microsoft public windowsxp hardware
(416)microsoft public money
(397)microsoft public windowsxp basics
(367)microsoft public dotnet general
(316)microsoft public windows mediacenter
(300)microsoft public windows inetexplorer ie6 outlookexpress
(276)microsoft public mac office
(272)microsoft public win98 gen discussion
(243)microsoft public sharepoint setup and administration
(225)microsoft public windows vista hardware devices
(183)microsoft public windows vista music pictures video
(178)microsoft public nntp test
(164)microsoft public windows vista performance maintenance
(148)microsoft public dotnet framework
(148)microsoft public visio
(128)microsoft public access 3rdpartyusrgrp
(68)microsoft public access conversion
(64)microsoft public dotnet xml
(58)microsoft public pt windowsxp
(38)microsoft public access developers toolkitode
(34)microsoft public windows live photogallery
(32)microsoft public dotnet faqs
(19)microsoft public dotnet framework aspnet datagridcontrol
(16)
microsoft.public.mac.office.excel
|
Post New
|
 Subject
|
Posted | Replies | From | ||
| |||||
page fields on pivot charts
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am new to MAC and Excel:Mac 2008. On Excel 2003, the page field can be shown on pivot associated charts, and the data manipulated directly from the chart. However, the "page field" does not show up on the pivot charts. Any help on how to display and use would be appreciated. |
6/6/2010 5:03:18 PM | 0 | j...@officeformac.com | ||
|
Charts/years
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I am trying to make a line chart that shows the number of dance notation systems invented each year between 1495 and 2009. For years at a stretch there are none. Some years there are 1 or 2 of any given type and never more than 4 a year in total. There are 6 different categories of notation system. So, in my data I have columns for each of the notation categories and a row for each year of invention. BUT, I cannot get Excel to accept these dates as just years - it keeps wanting to alter them to month and year. Is there a way aro |
6/6/2010 9:02:37 AM | 0 | vixwa...@officeformac.com | ||
|
Conditional Formatting "Duplicate Values"
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am using Excel to enter pipe numbers, on my PC I can use duplicate values to highlight the cell if a duplicate value is entered. Unfortunately I have not been able to figure out how to do this in EXCEL 2008 on my MAC. |
6/6/2010 2:45:29 AM | 2 | jori...@officeformac.com | ||
|
My spreadsheet prints the letter at the top of each column
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello! I'm trying to print some spreadsheets and every time I do, the A, B, C, D (generic) title of the Excel columns come out above my named titles for each column. Whenever I try to do "set print area" it includes the standard rows and columns that appear in gray. How can I remove these, as they are not necessary? <br><br>Thank you! |
6/5/2010 5:49:51 PM | 1 | marip...@officeformac.com | ||
|
Generating unique random number
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I need to select 5 items from a list of 50. When I use RANDBETWEEN(1,50), I get duplicates more often than not. Is there a different function or some simple way to generate 5 unique numbers? |
6/5/2010 3:02:34 PM | 2 | Iggle...@officeformac.com | ||
|
Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. |
6/5/2010 1:50:38 PM | 1 | money mania <texaspes...@gmail.com> | ||
| |||||
|
Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. |
6/5/2010 1:48:20 PM | 0 | money mania <texaspes...@gmail.com> | ||
|
Lost document
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Can anyone help??? <br> I have been working on an excel (Office for Mac) spreadsheet for a week. I have been saving it on my work network which I access from home through 'Shared' on Finder. I finally finished it tonight and saved it but wanted to rename the file. Instead of doing 'Save As' I double clicked file name and re-entered text. However, I think I accidentally used a character which shouldn't be used in filenames "/" and when I clicked enter, the excel file icon and the contents of the document di |
6/5/2010 1:03:19 AM | 1 | Charms...@officeformac.com | ||
|
Demand forecasting
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi i am trying to apply the arch modell to forecast a trend in demand for a little model i would like to use for my bachelor thesis but i dont quite get it. <br> I do have the mean and i do have the standard variance but i am not quite sure how i can use that in excel... Is there any way to make excel do that? <br><br>My data comprises a timeline over 4 months with each day connected to a certain amount of used goods. <br><br>However there is no linear trend. The historic demand is quite volatile. <br><br>Any suggestion how to |
6/5/2010 1:00:50 AM | 1 | jon...@officeformac.com | ||
|
Find and Replace
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi Everyone, <br><br>I have a spreadsheet that has almost 50,000 lines. In one column, I have a numeric value in each cell (a zip code, 90210, for example). I need to add the words "Zip Code" to each cell without losing the numeric value. I do not wish to type "Zip Code" 50,000 times. I did this once before using Find & Replace, but cannot duplicate it again. I know its a simple process, but I can't figure it out. Any suggestions would be great! |
6/5/2010 12:01:36 AM | 10 | Historygu...@officeformac.com | ||
|
Cannot open excel files - error message 'file might have been damaged or modified from its original format'
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I see this was an old discussion topic but have yet to find a solid solution. This problem whereby an existing file is worked on, saved and then will not open, is creating havoc with my excel documents. Error message is 'file might have been damaged or modified from its original format'!!?? <br><br>Help??? |
6/4/2010 9:59:56 PM | 3 | ...@officeformac.com | ||
|
Excel Compatibility Issues - PC/Mac
Hi! Our office is having an issue exchangint Excel files between the Mac and PC users. Recently an issue has developed where the PC users can open and use Excel files, but the Mac users cannot open them at all. They get this message: "The file might have been damaged or modified from its original format." We have tried: Saving it as .xls Moving it via flash drive instead of email. Moving it via a network location. We also tried copying and pasting the contents into a new document, and removing all the links. That worked... for a while. Today, when trying to copy and |
6/4/2010 8:12:59 PM | 1 | showgie <kathlee...@yahoo.com> | ||
|
Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi, <br><br>I am using a MacBook Pro with OS X version 10.5.8, and Excel 2008 version 12.2.4. <br><br>A colleague emailed me an excel file (.xlsx) from a PC, and when I try to open it, excel crashes and the following dialogue box opens "Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience." <br><br>Below is the error log. I hope you can help. <br><br>Thank you for your time. <br><br>Microsoft Error Reporting log version: 2.0 <br><br>Error Signature: <br> Excepti |
6/4/2010 7:28:08 PM | 1 | al...@officeformac.com | ||
|
Adjusting sheet size
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel If I put the cursor on the lower right hand corner of the sheet, I can no longer adjust the size of the sheet. How do I fix this? Thanks |
6/4/2010 1:52:06 PM | 1 | investd...@officeformac.com | ||
|
Categorising expense items
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello, <br> I want to assig/categorise an expense type to all my current account payments. I would like to do this by assigning a standard expense to each item from a drop down menu. How to do this is the problem. I have tried List Manager but I think the standard list needs to be created each month on each worksheet. This seems awkward. Surely there is an easy way of doing this? Your help would really be appreciated. <br> Thanks <br> Mike |
6/4/2010 10:13:53 AM | 3 | mikes...@officeformac.com | ||
|
Shading colours have gone whacky???
Version: 2008 Processor: Intel Hi there, <br> I have a spreadsheet going in excel with rows colour codes (via Formatting pallet / borders & shading / Shading. <br><br>Had the program minimised, when i reopened all the colours had changed to varying shades of pink and orange! <br><br>When I go back into the formatting pallet and look at the options, they have all changed too to these new shades and none of the old ones are available? <br><br>What the? is all i can say? anyone able to help? <br><br>Even if I open up a new spreadsheet, I only have the new colours, not the original ava |
6/3/2010 11:27:36 PM | 1 | M...@officeformac.com | ||
|
Sequential Cell Numbering
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I'm trying to create an Excel spreadsheet with one column indicating sequential line numbers; 1, 2, 3, etc.. My goal is to have a formula where, for example, the 6th line down displays 6 by adding 1 to the line 5 above it. The reason is if there are 50 lines I don't have to number each one manually but the problem I'm encountering is if one line is deleted then all subsequent lines show "#REF!" error message. The formula I created is "=IF(A5>0, A5+1, A4+1)", with the idea that if line 5 we |
6/3/2010 10:26:16 PM | 3 | E...@officeformac.com | ||
|
Sequentially number lines automatically
Version: v.X Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How can automatically number the lines as I enter data. <br><br>so box A1 would automatically be 1 <br> and the next time I created an entry on another line that line would be 2, etc. <br><br>The reason is so that I can sort, delete and the numbers will remain, so I can also go back to the order than things were entered into. <br><br>Could do this manually, but a pain. <br><br>Or could possibly do this with a date and time? <br><br>Thanks Steevee |
6/3/2010 10:19:40 PM | 1 | Stee...@officeformac.com | ||
|
Accents not keeping from PC to Mac
Version: v.X Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hello, <br> I am having issues with PC data showing up the same on my MAC. My partner generates a pre sorted data list from the customers original excel file. He has given me the data in a .csv, .dbf, .xls fiel but I'm running into the same problems with all 3 files. All the accents over the spanish names are being transformed into different characters. Just for giggles I tested all 3 Files on a different PC, and both the xls, and csv files were viewed perfect, but the dbf file had the same issues on the PC |
6/3/2010 6:41:52 PM | 1 | cmarge...@officeformac.com | ||
|
TOP ROW scerwed up.
Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel My intern, with out asking, changed the format of my workbook so every column has a sort button or whatever you call it (what this called) <br> We got that removed but the top row -- the header row is still in Grey color and when I select it, the whole workbook selects. How do undo this? thanks. |
6/3/2010 5:41:33 PM | 2 | kev...@officeformac.com | ||
|
Convert numbers stored as text to numbers in excel 2008
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Trying to sort a spreadsheet using a column that has numbers stored as text. When I sort, the number 1001 is ahead of the number 106. The numbers are all on the left of the cell. How do I convert? <br><br>Thanks <br> R |
6/3/2010 2:35:42 PM | 2 | rchamb...@officeformac.com | ||
|
deleted excel file
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Can't open or locate a frequently used file. When I go to most recent, message says it has bee moved renamed or DELETED. Any Suggestions? |
6/3/2010 10:50:47 AM | 1 | ...@officeformac.com | ||
|
Converting a string into a filename
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a workbook containing data pertaining to many separate weeks, months, quarters of data. Each week, month, and quarter is on a separate worksheet in the workbook. I'll refer to this as "Workbook A". <br><br>I have a worksheet (call it "Analysis") in another workbook (named "Workbook B") to which I want to add dynamic references to individual worksheets in Workbook A. For example, if I enter a week number such as "24" into Workbook B, I want it to use data from the |
6/3/2010 2:11:18 AM | 1 | Stanley_F...@officeformac.com | ||
|
PC excel 07 Vs Mac Excel 08
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi, <br><br>I am not tech/program savvy and need some help. I have had some work done by a provider in elance in PC excel 07 and now i can not read the spread sheet in my Mac environment. The provider is saying that MAX and PC excel versions are 100% compatible - I disagree and need to know the differences <br><br>1. What are the file extensions for MAC excel? Do they differ from PC excel? <br> 2. What are the differences between MAC excel 08 vs PC excel 07? <br><br>Thanks |
6/2/2010 11:10:43 PM | 1 | g_coo...@officeformac.com | ||
|
VLOOKUP problem
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel VLOOKUP Looks in the FIRST COLUMN of an array and moves across the row to return the value of a cell. <br><br>How would you do this same thing, except look up a value in a column BESIDES the first one, and return a value on the same row in a completely different column?? Does excel even offer this function? <br><br>This can be more useful... Let's say, for example, you have information saved in columns. The first column stores the names of some items, the second stores cost. You want to return the name of the it |
6/2/2010 10:11:34 PM | 5 | Thoroughb...@officeformac.com | ||
|
Formula result not displaying after editing VLOOKUP syntax
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I'm seeing a strange (and frustrating) behavior in which Excel displays only the formula in a particular cell, not the result of the formula. <br><br>Let me start by saying that in Preferences, I have Calculation set to Automatic and 'Show formulas' toggled off. <br><br>In my spreadsheet I've entered a simple (that is, not dependent on an IF or any other conditions) VLOOKUP function that refers to a named table array. The first columns are in ascending order, both in the named table array and the table in which |
6/2/2010 10:05:03 PM | 0 | icarus...@officeformac.com | ||
|
Formula Diascrepancy in Worksheet
I have the formula below working in two areas of my worksheet but not in the other. I get the infamous ########## sign return. Can someone help me out with this? Cell D111 Cell F111 1/24/2010 12:15:00 AM 1/25/2010 1:30:00 AM =IF(OR(D111="",F111=""),0,(NETWORKDAYS(D111,F111)-1)*("15:00"-"06:30")+MOD(F111,1)-MOD(D111,1)) Cell N111 Answer: 01:15 ****************** Cell D139 Cell F139 11/12/2009 12:22:00 PM 11/12/2009 12:36:00 PM =IF(OR(D139="",F139=""),0,(NETWORKDAYS(D139,F139)-1)*("15:00"-"06:30")+M |
6/2/2010 7:50:04 PM | 2 | =?Utf-8?B?d2F0ZXJtdA==?= <wate...@discussions.microsoft.com> | ||
|
Linear fit while fixing slope
Version: 2008 Processor: Intel Hello, <br> If a I have a set of x values and y values and I want to fit them with a line such that I fix the slope value to a certain number and fit the data to get the y-intercept. How can I do that in Excel? <br><br>thanks |
6/2/2010 4:17:58 PM | 1 | fermion...@officeformac.com | ||
|
excel f function keys
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) can i please have some help?????? <br> being new to the world of Mac i am doing a excel spreadsheet and i need to be able to use the F key functions. <br> what i am after is in excel 2007 when doing a formula you can turn part of it into a $ input by pressing F4, can this be done in Excel 2008 or how can i do it otherwise please advise <br><br>thanks Hayly |
6/2/2010 5:00:43 AM | 1 | hayly_Tuc...@officeformac.com | ||
|
opening tablet PC excel files
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel My professor (temple univ) lectures and posts notes in excel using a stylus on a tablet pc. When I open the file, all of his notes with the stylus are bunched and jumbled at the top of the screen and reflect none of the formatting done during lecture. The text is fine, but the writing overlaps and is illegible. <br><br>Can I view these on my mac? <br><br>Thanks. |
6/1/2010 11:10:52 PM | 2 | chrisdobro...@officeformac.com | ||
|
Locking worksheets for other users
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have prepared a simple calculator for sales staff to use. I have removed the toolbar, the column headers, row numbers, gridlines and split the pane. I have sized the window to cover just the relevant area. The worksheet now looks tidy and professional. <br> I lock the workbook and distribute it to sales colleagues. Now when they open it, the look is just like another Excel workbook with toolbar, column headers and row numbers. Plus the window covers a different area. I expect locking to mean locking - |
6/1/2010 10:08:03 PM | 0 | David_Na...@officeformac.com | ||
|
How do I add totaled labels to a column chart?
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have a graded column chart that features values for specific revenue streams on the y-axis and it is by year on the x-axis. I have all the revenue streams with labels for their values, but I want to add a label that will show the total amount of all the revenue streams added together for each year. How do I do this? I've been trying all combinations of data input and nothing is working for me. Thanks. |
6/1/2010 4:31:09 PM | 0 | alex.ma...@officeformac.com | ||
|
SMART Regression installation
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) So I am taking a statistics class. Our textbook comes with a disk and instructions to install SMARTReg, which provides additional regression features for Excel. (Yes, I do have the analysis tool-pak installed.) However, the installation is for windows (it is an .exe file). I went to the website listed in the ReadMe file: www.gierus.ca/alex/smartreg but it is definitely not related to this program. <br><br>Is there a Macintosh version of this add-on available that anyone knows about? <br><br>Thanks. <br><br>-EM |
6/1/2010 11:13:48 AM | 1 | ...@officeformac.com | ||
|
workbooks
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) how do you copy an entire workbook to a new workbook without having to copy each sheet one at a time |
6/1/2010 7:34:10 AM | 2 | jenny...@officeformac.com | ||
|
Excel page format changes
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello, <br><br>My client creates spreadsheets for her boss. She pushes the boundaries to get things to fit on the screen. <br> Uses A4, margins at 1.5cms and scales to 90%. <br><br>When her boss receives it by email the margins go to 2.5cms, scales to 100%. They have the same versions 12.2.4 and Leopard. They are just about to be upgraded to Snow Leopard. Any idea why this could be happening? Thanks. |
6/1/2010 7:28:48 AM | 0 | mkenn...@officeformac.com | ||
|
some .xlsm docs not formatted coretly
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have installed Office for Mac 2008 but am still have trouble with the formatting and links to embedded data in an .xlsm template that I mm required to fill in. It says , "Visual macros do not work in Mac office 2008 . To open the file and keep macros click Open." I click Open and it opens. <br> Then it says, "The workbook you opened contains automatic links to information in another workbook. (Th is is not accurate. The data is embedded inside this doc. I spoke to the woman who created it.) <br |
6/1/2010 1:58:53 AM | 2 | KateH...@officeformac.com | ||
|
Powerpoint icon for .xls files?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I recently did a clean install of Office 08, including all updates. <br> Funny thing (well, not really) is that all my excel files (.xls) now have a powerpoint icon. Powerpoint files also, as it should be. Word files (.doc) show up ok. <br> Any ideas how to solve this? I already changed the default application for .xls to neooffice and then back to excel but again got the poerpoint icons... |
5/31/2010 5:02:18 PM | 6 | Mr.C...@officeformac.com | ||
|
Deleting blank rows in excel
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have a set of numbers with 1000+ rows. Every other row is blank and I want to delete all the blank rows, how? |
5/31/2010 3:25:55 PM | 1 | pgenni...@officeformac.com | ||
|
auto format
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am new to using Excel to upload to my website. I have been successfully using auto format, however, I recently could not use the arrows to choose my cell to sort by. I think that I unknowingly hit a key to change a setting but have not a clue as to what. I have reset the freeze frame and the autoformat to no avail. There is NUM highlighted on the right under the scroll bar. Can someone help me get back to normal. I am no longer able to enter data using all the sort features. The arrows remain frozen. |
5/31/2010 12:44:29 PM | 0 | OverMyH...@officeformac.com | ||
|
Highlighting top row to last row in sheet
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is there a short cut that allows me to select the top row off my sheet and then jump to the last row so I can highlight the entire sheet, scrolling through 15000 lines is slow and tedious. <br><br>Thanks |
5/31/2010 6:12:54 AM | 3 | tau...@officeformac.com | ||
|
Paste stops working
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel After copying/pasting a number of objects within a spreadsheet, paste stops working -- it's grayed out in the edit menu and crtl-v no longer works. Pasting content within cells continues to work -- this only affect pasting objects. The only solution I've found thus far is to restart the app. |
5/30/2010 9:26:42 PM | 1 | Becky...@officeformac.com | ||
|
DAYS360
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Today is the 30th of May. I'm working on multiple projects and would like to see how many days I have to complete them. It appeared DAYS360 could help me do that. Unfortunately, it seems that DAYS360 has to convert months, like May, with 31 days into months with 30 days, and therefore can't precisely predict the amount of days between two dates. Is there a better way to get Excel to predict the number of days between two dates? Thank you, |
5/30/2010 8:11:46 PM | 5 | Dwad...@officeformac.com | ||
|
"File Reservation"
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I get a dialog titled "File Reservation" when I open any of my five Excel databases. The problem began last week after my iMac logic board was replaced. <br><br>The message is: [MyFile] is being modified by [Me]. (substitute file name and person) There is only one user with my name. <br><br>If I save the file under a different name, the problem disappears, but it returns when I delete the original file and rename the new file with the old name. Same thing with the folders they're in, puting a databa |
5/30/2010 6:34:24 PM | 3 | kenco...@officeformac.com | ||
|
Date Formats for Cells Do not match System Date Formats
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have just loaded Office 2008 and then update to the latest update 12.2.4 <br> I have my system preferences set to Australia for date and time using the date format dd/mm/yyyy. But in Excel when I open the format cell dialogue and select date the only formats available for selection are in the mm/dd/yyyy formats. When I checked in "Numbers" the dd/mm/yyyy format is used so "Numbers" is picking up the system preference why not the excel. |
5/30/2010 10:33:26 AM | 5 | Ho...@officeformac.com | ||
|
Excel Conditional Sum Wizard Totals
Operating System: Mac OS X 10.6 (Snow Leopard) Hi, <br><br>I've just loaded Excel onto my Mac and have been trying to do some conditional sums, however for some reason it will not allow me to display the totals on a separate sheet. It just keeps saving to the same sheet as the table, even when I select a cell on another sheet. Can someone please help advise how this is done? Or is this something that is not allowed? <br><br>Thanks |
5/30/2010 5:48:10 AM | 2 | w...@officeformac.com | ||
|
Excel cursor movement
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) when I use the arrow keys to move my cursor from cell to cell the sheet scrolls instead. I used to be able to move between cells using my cursor but all of a sudden it changed. <br> HELP! |
5/29/2010 7:01:18 PM | 1 | jacu...@officeformac.com | ||
|
Multiple Worksheets
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) How can I "automatically (or shortcut) move between worksheets without having to click on them? |
5/29/2010 12:02:56 PM | 0 | ge...@officeformac.com | ||
|
Multiple Worksheets
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) How can I copy same info between worksheets? |
5/29/2010 12:01:42 PM | 0 | ge...@officeformac.com | ||
|
issues with zooming
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel whenever i zoom from 100% to anything higher all the numbers that are made by formulos become "xxxxx" even if i double click make the cel wider the xxx dont go away. how can i fix this? |
5/28/2010 10:58:54 PM | 4 | JuanJavierC...@officeformac.com | ||
|
Previous Cell Comments Appearing when Mousing over cells in one column
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel I am seeing a previous cell comment when I mouse over another cell in a different column of cells. It only happens in the one column and its the same cell comment. How can this situation be fixed so I will not see this comment? Thanks. |
5/28/2010 7:11:43 PM | 2 | ...@officeformac.com | ||
Pages: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
Newest Articles
Window Live Mail Auto Forwarding27 min. 31 sec. ago
Win32.Gael.3666 got past Windows Defender3 hour 31 mins ago
ANN: IT COULD GO DOWN INTO THE 40's TONIGHT HERE IN THE WINDY CITY SUBURBS!3 hour 59 mins ago
ANN: THE PRICE OF SPEEDING TICKETS IS GOING UP HERE IN ILLINOIS!4 hour 3 mins ago
ANN: OBAMA WANTS 2 SPEND ANOTHER 50 BILLION!4 hour 15 mins ago
All Times Are GMT(UTC)