Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
0
votes
1answer
2k views

Merge two Excel spread sheets using a common column and retaining duplicates

There are two excel sheets. I am trying to merge the two files based on the id column. For example: first excel: id var1 var2 var3 1 5 4 5 2 3 2 2 ...
1
vote
2answers
2k views

Data validation - populating a drop down menu using a defined name

I am using data validation to create a drop down list on a worksheet. What I'd like to be able to do is set up a list of values as a defined name (Insert > Name > Define...) and then enter that ...
0
votes
3answers
78k 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
3k views

Spread Sheet Formula for Time Study

I need to create an excel spread sheet. I am doing a time study. ( The time a project was started to finish) I will be entering in times frequently in military time. I havent used excel for years and ...
1
vote
1answer
69 views

Calculating the cost of the electricity consumption

in Excel 2003, I use the following equations to calculate the cost of the electricity consumption. I have to use different equations for different consumption slice situations. The next figure shows ...
2
votes
2answers
5k views

Format Change Event for Excel VBA

I'm trying to prevent people from modifying (most) of my spreadsheet while still alowing them to use the sort function of the AutoFilter. What I've done so far is used the Worksheet_Change event and ...
8
votes
1answer
4k views

Why is the maximum row height in Excel 546px?

The maximum height of a single row in Excel 2003 is 546 pixels, or 409.5 points: http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx I'm curious as to why ...
12
votes
11answers
106k views

Adding more than 15 digits in Excel

I want to add more than 20 digits in an Excel cell. The current format of the cell is general, it converts the number to an exponential format. I tried with a number format and accounting, but when I ...
9
votes
6answers
45k views

Why is Excel removing 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 A2 attempts to display "01" as a number ...
2
votes
3answers
35k views

How to get Excel out of Select Cell mode

Looking for a tip on Microsoft Excel (2003): If you click on a cell containing a formula, click into the formula, and click away, Excel will enter the cell or range you next select into the formula ...
11
votes
10answers
67k 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 ...
1
vote
0answers
203 views

Difference between VBA for Excel 2003 running on Windows 10 and Windows 7

Okay, I have an oddly specific situation: I made a bunch of macros and Visual Basic code in an Excel 2003 Spreadsheet running on Windows 7. The product has been working perfectly for one and a half ...
102
votes
4answers
45k views

Excel: how to undo in current file only?

Microsoft Excel's undo / redo feature behaves unlike any other program I know. The undo stack seems to be global across all open files, so that undoing sometimes switches to another file and undoes ...
0
votes
4answers
4k views

Need excel function to filter alpha characters

I have a column in excel file which is mix of set alphanumeric,number and alpha character , I want to filter out alpha character only. Need advise.. Column 1 100054 Mk1568 Un10008 Dngh 34677 Gopro
2
votes
3answers
2k views

Using excel sheet as a function

I wonder how I can use an excel sheet as a function. Let's say I have a complex calculation in Sheet1 with one parameter I would like to iterate over a range like [1 to 400] in a second sheet to ...
4
votes
2answers
13k views

Changing line insert default formatting

When you insert a new row in a current spreadsheet, it automatically formats that row with the formatting from the line above. Is there a way of changing this so that it enters the formatting from the ...
5
votes
4answers
18k views

How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...
3
votes
3answers
16k views

255 Character limit on VLOOKUP

Using excel 2003, the formula: =VLOOKUP(D1 ,A1:B135, 2) fails if the length of D1 exceeds 255 characters (i.e. the list has some text longer then 255 characters, D1 has the same text value, and ...
29
votes
1answer
108k views

Limit an Excel cell to one of two possible values

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell. How could I do this?
27
votes
1answer
122k views

How do I put logical operators in an Excel =IF Formula?

I'm trying to enter a formula to display text according to an IF condition. The best I can manage is something like... =IF(myval>=minval & myval <= maxval, "OK", "Not OK") But this appears ...
15
votes
6answers
122k views

Select each nth row in Excel

I have an Excel spreadsheet with thousands of rows. I want to select every 7th row from that spreadsheet. (By "select," I mean delete all of the other rows, or copy the selected rows into a new ...
2
votes
6answers
8k views

Why do 2 excel (2003) files that are exactly the same have different file size?

I have two excel files that are exactly the same (in terms of the content of the file) but differ by quite a margin on file size. One file is 37.5 KB while the other is 56 KB. The only difference I ...
-2
votes
2answers
148 views

Condense column data with many blanks

I've seen this and similar methods posted here and elsewhere: How can I condense a list that has missing data to a new list without the cells with missing data? I have patient data, basically like ...
4
votes
3answers
13k views

How to find the last value in a column in excel?

I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...
0
votes
1answer
227 views

How to sort with spaces in Excel?

How do I sort with spaces? I have spaces between my numbers and dates and names and would like to sort them without using a VBA formula.
1
vote
2answers
637 views

How to create a two column pick list in Excel

I want to be able to have a pick list with two columns setup in a worksheet and pick from that list in another worksheet to populate two columns. Pick List Sheet would look like this A Item 1 ...
0
votes
5answers
31k views

How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...
24
votes
7answers
134k views

Export an Excel spreadsheet to fixed-width text file?

Excel has the functionality to import fixed-width text files where it presents a dialog that lets you choose where the begins and ends of fields are which it puts into columns. Does it also have ...
32
votes
2answers
208k views

Merge two excel files using a common column

I have two excel sheets. I have to merge the two such that the values in one match with the other. For eg. The first excel, the 2nd excel 1 t 1 tes1 2 5 3 ...
97
votes
7answers
660k views

Cells not updating automatically

I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when ...
9
votes
2answers
71k views

How to change font color in Excel based on cell value?

How do you change the font color of a column of cells based on their entered value? I've got a column with the heading at row 1 and the values starting at row 2 going on down. I want to change font ...
0
votes
1answer
118 views

Fixed cells width and height in Excel 2003

In Excel 2003, I want all the cells have width and height fixed to 2cm by 2cm; How can this be done?
1
vote
1answer
356 views

How do I add 1 month to a specific date once that date has passed?

I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do ...
1
vote
1answer
107 views

Worksheet limit in Excel 2003 (BIFF8)

Is there a limit in the number of worksheets ("tabs") allowed by the Excel 2003 format (aka BIFF8)? I can find plenty of information about rows and columns but not worksheets.
2
votes
3answers
3k views

De-pivot excel spreadsheet

Using Excel 2003 Can i... Given a spreadsheet of this layout with Permissions being Read = R , Write = W and No permission= X Users Perm1 Perm2 Perm3 ... ..... PermX User1 R ...
0
votes
0answers
49 views

2003 Excel Formula conversion to 2010 Excel formula

I am creating a payments spreadsheet to accurately calculate interest on overdue payments. My formula used in the 2003 version that I am trying to copy into an updated version is: =zInterest(...
1
vote
2answers
20k views

Converting Excel 2007 files to Excel 2003

I'm currently using a library named http://www.codeplex.com/ExcelPackage>ExcelPackage to generate a large number of Excel files. Unfortunately it saves in an xlsx format, the Excel 2007 OOXML format. ...
0
votes
1answer
156 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 ...
1
vote
2answers
1k views

Remove Excel 2003 macros easily

I am using Excel 2003 and I have some workbooks that I have to send several days a week to some recipients. These workbooks have macros in it and I don't want the people receiving the file to be able ...
1
vote
2answers
124 views

How to make sure that the text in TextBox in an excel is found when searched using CNTRL+F?

i have made a flow chart diagram in an excel sheet using TextBox tool from drawing toolbar. i've made entries into the text boxes.(No other data is present in the cells of the worksheet) But now ...
0
votes
3answers
108 views

Joining 3 Excel IF Statements

I'm trying to join the following 3 IF statements in Excel but every time i try i get an argument error or else it reverts back to displaying "True" or "False" instead of "Miss Window", "Hit", "Not ...
0
votes
0answers
172 views

Creating Cluster Column and Line Graph in Excel

I have created a clustered column chart where I inverted value so the series became the "categories" and the dates became series and just manually adjusted the coloring. I have attached an image. ...
1
vote
0answers
51 views

Whenever I open specific Excel binary file computer turns off without warning

Whenever I open an Excel binary file my computer turns off without warning. Even after repairing office the same issue persists. I can open other Excel files. How can I resolve this?
0
votes
1answer
28 views

In this data set, I want to get the most recent or three most recent numbers for a particular day. How can I get this?

This is the data set I have : Date Day Number 8/29/2016 Mon 63 8/30/2016 Tue 58 8/31/2016 Wed 66 9/1/2016 Thu 61 9/2/2016 Fri 61 9/3/2016 Sat 67 9/4/2016 Sun 70 9/5/2016 ...
0
votes
0answers
75 views

How to recover a .xls file that turned into .xls.XML file? - in windows 10

Can you please help me with this one? I have read few articles and questions here and there but there seems to be no answer at all. I have an excel file (sample.xls) that turned into sample.xls.XML ...
0
votes
0answers
76 views

Excel File Open Dialog Crash when selecting My Computer

In Excel 2003 using the File Open Dialog Selecting the My Computer or My PC from the dropdown selector crashes Excel everytime. This does not happen if other folders are selected. Have seen mentions ...
1
vote
1answer
61 views

Can a single cell in Excel extend over several pages? How?

I encountered this problem while trying to write really large chunks of text in Excel. In spite of of wrapping turned on, my text doesn't really get wrapped once it stretches over more than 12 lines (...
3
votes
3answers
5k views

Lost VBA when downgrading from Excel 2013 to Excel 2010

I am on Windows 7. In the past I was using Excel 2003. I installed Office 2013 and found that my Office 2003 was intact and I could run both versions. I made updates to some worksheets using Excel ...
3
votes
2answers
23k views

Can I use “Fill Down” to make a vertical series reference a horizontal series?

Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
0
votes
1answer
416 views

How to express a lone “\” in a file path in VBA?

I'm using a VBA script to save a file titled "month-day-hour-minute" inside of a folder titled "month-year" Anyways, excel doesn't like my code, ActiveWorkbook.SaveAs "C:\Users\" & Environ$(...