The 2003 version of Microsoft's spreadsheet application.
0
votes
0answers
40 views
How to avoid sorting rows copied from other rows?
I have a payroll that contains 30 names of workers. I sort this payroll in three different ways: 1) ORDER 1; 2) ORDER 2; and 3) GROUP.
I have copied the names into another group of rows, every one ...
0
votes
1answer
27 views
Close Full Screen window does not go away in MS Excel 2003
I have a problem or bug in MS Excel 2003 where the close full screen mini window does not move or go away. No matter what I do, I cannot move the window or even click any of the options.
I'm ...
-2
votes
2answers
118 views
Nested IF formula
I want a formula that will capture the following three scenarios below. In column S, I have Orange in cell S2, Mango in cell S3, Grape in cell S4, Pawpaw in cell S5, Onion in cell S6, Apple in cell ...
0
votes
1answer
66 views
If cell B1=1 then DELETE cell A1 (excel 2003 formula) - How to do it?
I work with Excel 2003.
If cell B1=1 then DELETE cell A1,
and if cell B=0 then UNCHANGED.
How can I do this?
Example:
http://oi33.tinypic.com/mwsm03.jpg
Many thanks :)
0
votes
1answer
86 views
Excel Time Subtraction
I think there is a way around the time subtraction issue I have in Excel. The problem is that when the time in cell F (for example 11:29am) is less than the one in cell A (for example 11:30am), the ...
0
votes
0answers
50 views
Excel 2003 Macro runtime error 1004 application-defined or object-defined error
We are using a macro to remove rows of data from our excel 'database' that have been tagged as being completed/done. this is the coding ...
Private Sub cmdRemove_Click()
Dim varResult As ...
1
vote
1answer
52 views
Referencing the sheet name is not working [duplicate]
I'm trying to get the sheet name into a cell. I've tried using:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)
but my Excel 2003 displays an error when I try to enter the formula. ...
2
votes
2answers
74 views
Why is this simple Excel calculation not netting Zero?
It's supposed to be zero but for some reason the result produces a peculiar series of digits at the end.
Also, here's the .xlsx of it: http://83.212.111.36/Book1.xlsx
0
votes
1answer
44 views
Unable to add, create, or remove drop downs on an Excel 2003 spreadsheet
In Excel 2003 the Validation option under Tools is grayed out for a specific workbook. The sheet is not locked or protected, but it is shared. Even the author of the sheet has the Validation grayed ...
0
votes
1answer
27 views
Add time to current-row by previous column in an excel column?
I am trying to add 20 minutes to the time in the previous column on the same row, using Excel 2003. Is this possible? I'm having trouble figuring out how to get the current row. I can just use D to ...
0
votes
1answer
98 views
MS Excel 2007 Warning Significant loss of functionality
I have created a template in MS Excel 2003. In MS Excel 2007, when I save it in MS Excel 1997 - 2003 format, it gives a compatibility warning;
Significant loss of functionality
This workbook ...
0
votes
1answer
135 views
Scatter diagrams with group labels for X/Y coordinates
I'M trying to create a map layout from an Excel spreadsheet in Excel 2003.
I have x and y coordinates in columns as well as group name and place name. I tried using a scatter chart but I can only ...
1
vote
0answers
60 views
How to validate formula easily in excel 2003?
when review excel sheets done by others, i have to do the work to validate all formulas contained in the workingbook, hower it's a frustrating process to trace the quoted cells,sometimes even in ...
1
vote
0answers
21 views
Windows Xp, Excel 2003 automatic start on bootup and yes to update
I need to start an excel file on startup. However when opening the software always ask if the user wants to update the files. How can I get Excel to automatically do this every time?
0
votes
2answers
84 views
excel conditional formatting AND isnumber
I'm trying to get my format sentence to work, but it just won't
I want to format the cell green if the cell is greater than the cell before it (and that cell contains a number)
I'm trying:
...
1
vote
0answers
52 views
can't select the shape in excel
I have a problem today that is the first time I meet it. I have opened an old file (this file from 2005), then this contain of flowchart which made from excel's autoshape.
Then I want to make some ...
1
vote
1answer
73 views
Excel membership list
I have a membership list like this in Excel
| A | 02-02-1994 | B | C
| D | 04-10-1998 | E | F
I want to change it, so it can be ordered by age (the 2nd column) or by name (the 1st column)
As you ...
0
votes
2answers
105 views
Incorporate VBA and Copy and Paste
I wonder whether someone may be able to help me please.
I'm using the code below to autopopulate a number of columns with pre-defined text when a value is entered into column "B".
Option Explicit
...
2
votes
2answers
254 views
Lock Empty Column Cells But allow VBA
I wonder whether someone may be able to help me please.
I'm using this spreadsheet to record staff resource.
As you can see in column B, there is a value of "Enter your name", which instructs the ...
4
votes
2answers
261 views
Restrict and validate date format in Excel
I'm trying to put together a 'Data Validation' formula which restricts the user to entering a date in the following format: dd-mm-yy.
From the research I've done, I've come across what I thought ...
0
votes
1answer
53 views
Subversion and excel xll file
It is a business requirement to keep xll files in subversion (trust me, I did not come up with this idea :-) ).
Now when I try to load this file up in Excel, Excel opens it like what you see in ...
2
votes
1answer
50 views
Change a color of a cell from one cell in sheet2 when making reference to it in sheet1
I'm trying to change the color of a cell in one sheet when made a reference in another sheet.
Sheet2 is a list of addresses and I want these to turn red when I use them in the main sheet on sheet1. ...
-1
votes
2answers
99 views
I will need a formula showing counts, totals and sub-totals for data set from different sheet
I am using MS2003 EXCEL. I have a cell in Sheet 1 with a color value and totals, with sub-totals. On sheet 2, I have a data set with 3 columns (colors, dress, type). On Sheet 1, I will need a ...
0
votes
1answer
98 views
Macro to count the number of text strings in sheet in Excel 2003
I have a worksheet for scoring.
I have a list in the first sheet that will be for data entry starting with a2 and going down the sheet, this is for Player names.
I have a summary sheet named "Place" ...
1
vote
1answer
125 views
Automatically select last row in a set in Excel
In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...
1
vote
1answer
170 views
Create or Open an .xlsx file having >256 columns in MS Excel 2003 with compatibility pack installed
I'm using Microsoft Office 2003. I have installed 'Microsoft Office Compatibility Pack for Word, Excel, Powerpoint 2007' to support new xml based formats (.docx, .xlsx, .pptx).
Now given that I have ...
0
votes
2answers
99 views
How to clear all value cells in an entire 2003 Excel workbook by one go?
How can I clear all value cells in an entire 2003 Excel workbook by one go?
I could do one sheet by going to special functions, however, if a file is composed of many sheets, it would take a lot ...
1
vote
2answers
46 views
Hide a number that comes before the text of a column in Excel?
I have a column like this "2;#Vendor", I want to display only "Vendor".
How can I do this?
2
votes
3answers
1k views
How to make multiple Excel files open in ONE window/instance of Excel 2003 in Win 7
I'm running Excel 2003 on my new Windows 7 machine. (There is also a Excel 2010 starter pre installed that I do not use).
I'm a heavy user of Excel. I use it all day every day. I often have 10 or ...
3
votes
2answers
159 views
Excel cutting out down over 1024 characters
I am using Excel 2003 to save a large file as a CSV.
But when saving cells that contain over 1024 characters, it cuts out the characters beyond 1024.
Per a previous question, I am using this ...
-2
votes
1answer
65 views
How to merge data B and C cell into A cell and applie the same to all rows
I have a data in Column A1 some data and I want to combine data from Column B1, D1 and E1 to Coumn A1, how do I do it using macro in excel 2003.
0
votes
0answers
52 views
Extract features from an Excel Workbook and reconstruct it based the exported information
I have a rather complicated Excel 2003 workbook that crashes from time to time.
I find that if I reconstruct the workbook from the ground up (it means a long painful process of export and reimport ...
0
votes
0answers
60 views
Entering a null value from the keyboard or using menus
How do I insert a NULL value into a cell using the keyboard or a menu option?
For example, in some programs, typing CONTROL + 0 results in a null value being inserted and the text "NULL" being ...
1
vote
0answers
280 views
How to Search For Excel (2003) Files which Contain Macros on Server?
*Q:*How would I search for Excel files and only those that have VBA code contained inside of them?
Any efficient ways to do this?
The way I'm thinking of would be to use vbscript and recursively ...
5
votes
4answers
2k views
Excel's date format without a year
I'm putting in employees' birthdays, but they come without years for sensitivity reasons. But when I put the month and day in, Excel automatically adds 2012 as the year! Obviously this is not right. I ...
0
votes
2answers
383 views
Excel 2010 formula conversion to Excel 2003
I am by no means overly proficient with Excel, I know enough to do the basics.
After much forum and soul searching I had come up with the following formula, which I will discuss what it is supposed ...
0
votes
0answers
208 views
Can I convert excel 2003 addin files into Excel 2010 xlam programmatically?
I read the doc here: http://office2010.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx#BM4
which says
On the File tab, click Info, and then ...
1
vote
1answer
334 views
I need excel to help group events within hours during a single day
I am very new to excel and cannot figure out how to take a group of times throughout a single day, which correspond to events in that day, and graph how many events occur during each hour of the day. ...
0
votes
1answer
99 views
Excel chart tabs are showing up as blank
All of my Excel 2003 chart tabs are showing up as blank. This includes both newly created chart tabs and chart tabs in existing spreadsheets, as well as both pivot table charts and regular charts.
...
3
votes
2answers
654 views
Move to end of selection in MS Excel (2003)
I have a large set of data that I update regularly by copy/pasting and overwriting old data. I do this for 10k-15k records at a time. Once I have pasted, I manually scroll down to the last line of ...
1
vote
1answer
161 views
Convert multiple rows into single column based on values
I have a excel sheet as
A 1 2 3 4
B 1 2
C 1 2 3 4 5
I need the output to be looked as
A 1
A 2
A 3
A 4
B 1
B 2
C 1
C 2
C 3
C 4
C 5
I will be greatful if anyone will help in finding a solution ...
5
votes
3answers
921 views
Converting decimal number of hours into time
I need to convert number of hours, such as 156.90 to 156:54 in excel 2003.
All of the conversions I found did this incorrectly. The number of hours shouldn't be changed, only the decimal.
0
votes
2answers
110 views
Compute the first digit of an integer in Excel
I have a spreadsheet with column B having integers. I want to get the first digit of each entry in column B in the corresponding row of column C.
1
vote
1answer
222 views
Microsoft Excel 2003 - Merge by Column
I'm trying to merge two excel files, here is the structure of the files:
[A] [B]
I want to add the column B from one file to another as column C, but the thing is that they have some rows under A ...
0
votes
2answers
125 views
How can I speed up my macro in Excel 2003?
I have a macro that copies data from one cell to another and uses a VLOOKUP formula, among other things. My spreadsheet contains nearly 2000 rows.
When I run it in Excel 2003, Excel starts to slow ...
1
vote
1answer
170 views
Why has Excel stopped offering to sort adjacent Columns?
Xp3.
Excel 2003 (11.8346.8341) Sp3
In the past, whenever I selected a columns that was next to another column and selected "sort", Excel would offer to sort the adjacent columns well. This was very ...
0
votes
1answer
66 views
Copying and pasting in Word and Excel
I recently started having problem with pasting tables between Word documents and from Excel to Word. For some reasons it pastes table without frame, just disorganized text. It is very annoying because ...
4
votes
2answers
5k views
Why is Excel removing leading leading zeros when displaying CSV data?
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...
2
votes
3answers
1k views
To much text for an Excel cell
What do I do when I have more text in an Excel cell than I want to (was "can") show in the allocated space?
(Something making it "scrollable")
0
votes
4answers
97 views
How to resolve #NAME? error in Excel?
I'm use Excel 2003. There is numeric information in Cell AI in my Spreadsheet. The cell is formatted as numeric with 4 decimal places. In Cell AK, which is also formatted as numeric, I type =AI and ...
