Applications

Thread preview

Thread	Last Post	Replies

xlxs formats as currency as dollars when you open the file	08 Apr 2008 03:08 GMT	12
I format a cell currency as £ and save it in the new xlxs format. When I open up the file again the cell currency is now formatted as $ again Any ideas anyone ?
Saved .txt as Excel workbook but no xls extension	08 Apr 2008 00:40 GMT	3
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I saved a .txt file as an Excel workbook, but surprisingly, I do not see an xls extension, I see the same .txt
multiple sheets with charts, but charts all refer to data in one sheet...how do I make them refer to data in their respective sheets without remaking the chart?	07 Apr 2008 21:37 GMT	1
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I have multiple sheets containing lists of data that change with pressure and temperature inputs. I have 28 series that need to be plotted on each graph, and the data for each series changes with each new sheet ...
rotate a column into a row	07 Apr 2008 21:34 GMT	2
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I have a very large column from one spreadsheet that needs to become the header row for another spreadsheet.
dividing numbers and getting percentage	07 Apr 2008 19:39 GMT	1
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC I want to take a list of numbers which are already added up, and get the percentage of each one. Help.
Original spreadsheets?	07 Apr 2008 18:55 GMT	1
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC Like the when you open up 2004 and there is that one big spreadsheet? Where is it in 2008. It opens up with like a million tiny spreadsheets that are worthless to me.
converting word list to excel data merge document	07 Apr 2008 16:35 GMT	3
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I was recently sent a list of 250 names, addresses, etc., that I need to merge into form letters and labels. The info sent to me looks like this:
Multiplication Bug	07 Apr 2008 15:27 GMT	4
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel Is there a way to work around the fact that when I ask Excel to multiply 310,676 times 4.22 it gives me 1,310,000 (rather than the correct answer, ie, 1311052.72)?
Sorting/filtering 2 columns for data found in both columns.	07 Apr 2008 15:25 GMT	1
How do you get Excel 2003 to filter/sort/??? 2 columns for data found in both columns? Thanks and God bless, :)
Sorting/Filtering/??????	07 Apr 2008 15:19 GMT	1
How do you get Excel 2003 to filter/sort/??? 2 columns for data found in both columns? Thanks and God bless, :)
Changing Line Numbers in Excel	07 Apr 2008 15:09 GMT	1
Version: 2004 Operating System: Mac OS X 10.3 (Panther) Processor: Power PC CHANGING LINE NUMBERS IN EXCEL
Avoid Excel from Opening in different instants of excel.	07 Apr 2008 13:16 GMT	2
When I open more than one excel file (eg: test1.xls and test2.xls), bothe files are opened in a new instants of excel. Hence I can not give links between files using formulae. I tried checking/un-checking "Tools - Options - View-Check Windows in
autocomplete doesn't work	07 Apr 2008 04:38 GMT	2
Version: 2004 Operating System: Mac OS X 10.5 (Leopard) The autocomplete feature on my Excel -- where you begin to type in a name and the program gives you a choice of which previous names to pick -- works but only sporadically. How do I fix this?
Excel Cell Editing vs Windows	06 Apr 2008 19:47 GMT	2
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I know when I used excel on the PC I could price F2 key and it would allow me to edit in the cell directly, without having to click on the cell (which is what I have to do now on Office Mac 2008. Is there a ...
Unwanted automatic number-to-date conversion	06 Apr 2008 19:39 GMT	4
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel I have been trying to type a win-loss record (e.g. 4-0) in excel but every time I type it excel automatically converts it to a date (4-0 goes to Apr-00). How can I change this unwanted autocorrect option*.