The 2003 version of Microsoft's spreadsheet application.

**0**

votes

**4**answers

2k views

### custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...

**6**

votes

**2**answers

28k 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 ...

**46**

votes

**5**answers

67k views

### Cells not updating automatically

I seem to have a problem with an excel file. I have a formula in a cell which counts the values in 2 other cells, however, normally after entering in the values in the 2 other cells, the formula cell ...

**0**

votes

**0**answers

28 views

### How do I format numbers with abbreviations in Excel 2003?

In Excel 2003, is there any way to format positive numbers with abbreviations (specifically K, M, & B) while displaying all decimal places but not trailing zeroes like so:
878.1K
100M
1.478B
...

**1**

vote

**2**answers

3k 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 ...

**9**

votes

**2**answers

22k views

### Hyperlink font in Excel always changes to the default font face/size

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).
How can you configure Excel to use the same ...

**0**

votes

**0**answers

15 views

### Cannot use Buttons with VBA in 2003 but can use buttons from same sheet in 2010 Excel

I have excel 2003 and 2010 installed on our computers. I reinstalled both, did a system restore. I manually uninstalled all updates from the past month (this started happening 1-1.5 weeks ago) I am ...

**1**

vote

**2**answers

14k views

### How do I group rows in a spreadsheet and keep them together after sorting?

I have a spreadsheet with the information set up as such:
ORDER PLU/Recipe # Name/Desc Components
2 27905 CINNAMON CRUMB CAKE SQUARES
2.01 ...

**0**

votes

**0**answers

43 views

### Broken ActiveX in Excel 2003

I hope this is the correct forum to post this, I believe this to be an Excel issue.
Ever since I upgraded to Win 7 (64 bit), whenever I try to add an ActiveX control to a worksheet in Excel 2003, I ...

**0**

votes

**2**answers

4k views

### Macro to open excel hyperlinks

I would like to know if anyone can help me do a macro to open a list of hyper links.
I have a list of about 600 hyper links all in a column in separate rows, I have to open each one to see if the ...

**2**

votes

**3**answers

156 views

### Convert Excel data

I've made a survey in Sharepoint and want to convert the results into something useful in Excel 2003. My problem is the format the responses are in for some questions.
An example of two responses ...

**0**

votes

**1**answer

13k 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 :)

**1**

vote

**1**answer

3k views

### How to create an Excel SUMIF formula that can compare different date formats

For my source data I have a column of dates in the dd/mm/dddd format, and a column of values next to it.
eg
03/02/2014 5
17/02/2014 4
03/03/2014 5
17/03/2014 4
On a summary sheet I have a ...

**0**

votes

**1**answer

21 views

### How do I copy list to another spreadsheet only if items have been paid?

I have a list of invoices. I want only the invoices that have been paid to be copied to another worksheet. My column headings are:
Inv. # / Date of Inv. / Amount / Customer Name / Date Paid / ...

**0**

votes

**1**answer

46 views

### VBA Code for changing background text for any text within a cell

I'm trying to make a row change colour to yellow based on if any text is within the D column. I have already set up 5 different colours for another cell, however need this to over-ride those ones. I ...

**0**

votes

**1**answer

329 views

### formatting date time as 01/01/2015 in excel 2003

If I enter 01/01/2015 into an Excel column it gets translated into 1/1/2015. I right click and click on Format Cells... and see that the format is *3/14/2001.
I have some other cells in this ...

**0**

votes

**1**answer

37 views

### Excel Validation Feature to Return Items from a List

I have a list of bank code and bank description in spreadsheet. i wanted to select a bank code from a list and then display the bank's description. How can i perform this ? Sorry im new with excel ...

**2**

votes

**1**answer

2k views

### Zero values in Excel logarithmic chart: Can the warning be suppressed?

I'm plotting data in an Excel 2003 chart with a logarithmic scale on the Y axis. Some data points are occasionally missing, and this is represented by blank cells. The resulting graph looks like the ...

**6**

votes

**3**answers

18k 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 ...

**0**

votes

**1**answer

65 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

**1**answer

29 views

### Microsoft Excel 2003 Sequence numbering

I am in need of working out how to have sequence numbering in the excel database I'm creating.
I am trying to have the following
001/15,
002/15,
003/15...
I am having no luck in getting this to work ...

**1**

vote

**0**answers

320 views

### Macro to copy and insert rows by variable number

I have an Excel 2003 worksheet with names and addresses, unique per row, to be used for shipping monthly magazines.
Some members receive more than one copy of the magazine, which will be indicated in ...

**0**

votes

**0**answers

44 views

### Show Excel column filter information in cells - Not working

I am on a W7 64bit pro edition, on a Lenovo T420
With regard to Show Excel column filter information in cells, is there a reason why it is not working in Excel 2003?
Thanks in advance
Gilberto
PS
I ...

**3**

votes

**4**answers

8k 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**

votes

**1**answer

172 views

### Excel, deleted data recovery

How do I make sure that in Excel, if I delete some sensitive data and send the file around this is not recoverable?

**0**

votes

**1**answer

111 views

### Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...

**0**

votes

**0**answers

11 views

### Excel experiencing one-time delay during saving and quitting

On my work machine I have Excel 2003. The first time (per instance) I try to save a file or quit, there is a noticeable delay. For saving the delay is somewhere around 10-15 seconds and for quitting ...

**2**

votes

**2**answers

67 views

### How to extract remainder of a match of 5 digits in 9

I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...

**6**

votes

**5**answers

41k views

### How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of
the times in minutes.
The cells in the Excel are like below:
A B C
1 6:38 8:23 1:45:00
A is ...

**2**

votes

**3**answers

26k views

### How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...

**0**

votes

**1**answer

71 views

### How to extract reminder of a match in MS Excel 2003

I tried using various combinations of functions but it seems that there's no specific function can return non-searched/matched values. Doing it manually takes days cause of the large amount data that ...

**0**

votes

**0**answers

31 views

### Query priority .xls VS .mdb

Hello to all the superusers!
My new question regarding conflict problem betweend an access application ad a excel wookbook/worksheet
I have a worksheet where using "Get External Data" on the "Data" ...

**2**

votes

**7**answers

22k 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 ...

**4**

votes

**5**answers

17k views

### How to avoid double quotes when saving Excel file as Unicode?

I have an Excel file with Unicode content of which some cells contain text inside double quotes, for example "text".
When I save the Excel file to a text file in Unicode format, the text which ...

**0**

votes

**1**answer

290 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 ...

**0**

votes

**1**answer

52 views

### How to replicate an anchor tag in Excel

I have an Excel (csv) like this:
column1 link
yahoo <a href="www.yahoo.com">Yahoo</a>
google <a href="www.google.com">Google</a>
Is there any way to make link ...

**2**

votes

**1**answer

41 views

### How did I hide a Microsoft excel 2003 formula?

I have a problem with a spreadsheet that I have had for some years and cannot recall how I managed to set up the condition that the formula takes.
I keep a record of fuel costs whereby I enter the ...

**2**

votes

**2**answers

49 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 ...

**2**

votes

**1**answer

167 views

### Make dates appear on the X-axis and the color category appear on the Y-axis

There is probably a fairly straight forward answer out there but I can not seem to find a solution online.
I have a table marked up like this (column names are in bold)
audit date | blindness
...

**0**

votes

**3**answers

2k 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 ...

**-3**

votes

**2**answers

69 views

### How do I convert list to table in Excel 2003

I have a list:
date item name quantity
1.7.2014 A 5
1.7.2014 B 2
1.7.2014 C 10
2.7.2014 B 5
3.7.2014 A 1
...

**0**

votes

**1**answer

256 views

### excel 2003: file too big even its empty

I have one excel file that consist of 3 sheets. Each sheet consist of text and image. The file grow up until 171KB. Then I copy one sheet become single file and save as a new file (newbook.xls). And I ...

**5**

votes

**2**answers

7k 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 ...

**0**

votes

**0**answers

52 views

### How do I pull rows from one sheet to another sheet automatically as data changes?

I currently use excel to create a shopping list to make it easier at the store. All rows have an item name, cost, and total based on the qty entered in the A column. Is there any way (with little to ...

**0**

votes

**0**answers

905 views

### Recover data from corrupt excel file

a friend has a corrupt excel file. When you attempt to open it in excel it says "File format is not valid". None of the tricks here work.
The file is Excel 2003 format. She sometimes edits it on ...

**7**

votes

**6**answers

15k 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

**1**answer

249 views

### How to display particular workbook of Excel file on TV and no matter what i do on the computer the TV displays the workbook [duplicate]

I have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when I work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I need that ...

**2**

votes

**1**answer

784 views

### How to filter out data between two columns?

I have data in my excel sheet in the below format
A B
1 2
2 3
3 5
4 8
5
6
7
8
9
i.e colA has values 1 through 9 and colB has 2,3,5,8. Now what I need in ...

**2**

votes

**5**answers

7k 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 ...

**9**

votes

**4**answers

30k 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 ...