Threads Replies Last Post 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38   Date incorrect in excel For some reason that has just started....When I type a date into Excel the year comes up wrong . For example when I type in March 1....and press enter....it comes up March 1, 2017 instead of 2006. I have tried reinstalling to no avail......any thoughts?... 3 11.01.2006 13:18:05 Landscape and Portrait Is it possible to set up Excel to print part of the worksheet in landscape and part in portrait as you can in Word for sections. Thanks... 3 12.01.2006 15:21:02 excel link updating between 2 workbooks Hello, In excel 2003 I have a spreadsheet with a cell (A1) that links to a cell in another workbook (B3). if the source & destination files are both opened and I insert a row in the source file, the reference in the destination sheet automatically changes to recognize the cell change. However, if I save the destination file,then insert another row in the source file, the reference ... 2 12.01.2006 10:56:19 Ezcel crystal ball how do I load crystal ball add-in?... 2 12.01.2006 10:28:50 page set up on excel to get 100% @ time of printing When I go to page set up and my margins are set to 65% but when I go to print preview I adjust my page breaks so it can print all my columns on one sheet while keeping my writing fairly large at 100%, so when I go to print it goes back to 65%, is there a way to keep my writing at 100% while printing... 1 10.01.2006 20:40:02 Is it possible to stack tabs in a row? I have a work sheet that has approximately 50 tabs and I would like to put the tabs in 2 rows opposed to just one row. Is thi possible... 2 10.01.2006 18:59:13 autocalc to complicated to turn off Please make it better in office 12 to turn off autocalc. At the moment it is a pain in the bXXX I managed to get it working for new Excel 2003 sessions but then I get no Sheet1. Lars ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If... 3 10.01.2006 00:31:02 i am having margin problems when converting EXL into PDF hi, i am converting exel files into pdf files, and having problems with the margins. it seems that it automatically puts a big margin on the left and right of the sheet, even when i set the left and right margin to zero. is there a way to change this? please help. thanks. m. 818.840.1725... 1 09.01.2006 21:24:02 Print Column Headings I am trying to print my column headings (the contents of row 1) on each page, but Excel is not having it. I have the pane frozen, so that row 1 is always visible on the screen when I scroll. In the past, this has also given me the column headings on printouts, but not this time. "Help" tells me to use the "Rows to repeat..." setting in "Sheet" under print setup. However, the option is gr... 3 09.01.2006 19:13:02 drop down menu Hi, Is there a way to have a drop down menu in an excel spreadsheet point to a list on a SharePoint site? Thanks...... 1 09.01.2006 02:20:02 Text File Import leaves a blank row after each line I am using a spreadsheet in Excel 2003, where I am importing a fixed length text file and is working perfectly. However, the spread sheet when used on a colleagues computer, while importing data from the same text file, leaves one blank row after each text file record. Is there any setting in Excel to prevent this? What could be the problem. ... 1 08.01.2006 14:07:03 sum won't show when highlighting a series of numbers For 2 years, when I highlight a column, row, or block; the sum appeared in the lower right of the screen. No longer. How do I get this feature back??... 2 08.01.2006 06:15:05 Anyone have a simple shipping log or packing slip in Excel? ... 2 08.01.2006 00:19:48 Arrow keys to move in Excel 2003 Spreadsheet? How can I enable arrow keys within formulas in Excel 2003 spreadsheet?... 2 07.01.2006 17:31:56 Formula Help - Number to Time OK I get a report from my firewall every month that shows how much time each user spent doing things on the internet. The final number in the column for a sample user is 94079 Can anyone help me with a formula that would turn that into HH:MM:SS if you figure it out with a calculator it comes out to 26h 7m 59s but I would like to get Excel to do that for me. Thanks for your help!! M... 2 07.01.2006 05:35:02 Combining spread sheet info I have two spread sheets, let's call them A and B. A could be considered the master work sheet. It has 15 columns A -O. The B worksheet has 13 columns, all of them which come from A. I have deleted Columns L and N in A when the data is transferred to worksheet B. I would like to know what the process is to set these up so that when I add or delete new information to or from A, it auto... 1 07.01.2006 00:57:26 Automatic CSV Data Conversion Hi, We are using Excel 2003 on a Terminal server 2003. On some user profil when i open a CSV file, excel will automaticly convert it using ";" as separator. On some other profil it will not. How do i setup it so Excel may do that automaticly. thanks! -- Guillaume Genest Network Administrator... 2 06.01.2006 22:19:51 check percentage or whole number Is there a way to check if a user enter a percentage or a regular number into a cell, then apply different formula to it? Note: user will enter a huge number like 2,345,678, or 22% (of something)... 4 06.01.2006 20:49:24 web page setup Is there a way to automate excel to send excel file as a web page to are web site ? -- Larry Young Logistics Superviser... 1 06.01.2006 17:03:03 Solver does not work from Macros We have a spreadsheet that is shared by three users. The spreadsheet has worked for all three without any issues in the past. Not too long ago the solver used in the macro for the spreadsheet stopped working for two of the users but is fine for the third user. The Solver options are the same for all three. They all have the same versions of solver.xla. The solver works if started... 2 06.01.2006 16:15:05 thousand separator I require to format my excel sheet using Indian system of formatting number to use thousand separators which is like ##,##,##,##0.00 and not as ###,###,##0.00. I have already changed the regional settings in Windows Contol Panel suitably and checked the suitable option in Excel/Tools/Options to select thousand separator as per system settings. Still my number are formatted as ###,###... 6 05.01.2006 10:32:05 change column designators from numbers to letters in excel how do i change column designators from numbers to letters in excel... 2 05.01.2006 00:35:48 I get message "cannot find directory" with ExcelTools Menu I canged some of my personal directory name and deleted others. Now when I run Microsoft Excel xp and try to go into the options menu and click on any one of the tabs, I get aqn error message that says: Can not access directory and it show a directory name tat I have deleted previously. If I re-create the directory and place no files in, the error message goes away.... 3 04.01.2006 23:33:28 Input Box I'm trying to create a VBA scenario in Excel 2003 where an Input Box appears asking the user to type a desired cell range (e.g. A1:B6) from a specified worksheet (e.g. Sheet1) in the Input Box, and then have the values that sit in whatever cell address range the user typed in the Input Box to copy and paste to another specified worksheet (e.g. Sheet2). In other words, if the user types ... 3 04.01.2006 17:34:03 How to combine several worksheets I run a smallish job placement office with 15 workers who, for various reasons, should not have access to each other's records. Each member of my staff has an Excel spreadsheet showing all of their clients and data about each client. I need to create a spreadsheet that shows all of the information from the various spreadsheets (which are all similarly formatted). Additionally, if at all... 2 04.01.2006 17:05:03 38 Pages: <<  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36  37  38