The 2003 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

90 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

**0**answers

1k views

### How to Search For Excel (2003) Files which Contain Macros on Server?

How can I search for Excel files that contain VBA code, are there any efficient ways to do this?
The way I'm thinking of would be to use vbscript and recursively search through the directory, open ...

**8**

votes

**8**answers

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

**2**answers

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

**1**

vote

**1**answer

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

**2**answers

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

**4**answers

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

**1**answer

571 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

**3**answers

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

**2**answers

275 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

**1**answer

662 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

**2**answers

589 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

**1**answer

612 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

**1**answer

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

**7**

votes

**4**answers

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

**4**

votes

**4**answers

34k views

### Too much text for an Excel cell — how to make the cell scrollable

What do I do when I have more text in an Excel cell than I want to show in the allocated space?
Something making it "scrollable" would be preferred.

**0**

votes

**4**answers

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

**1**

vote

**1**answer

55 views

### How can I print several spreadsheets at specific times?

I have an Excel workbook that has several worksheets in it. Is there a way one sheet automatically print at 8:00 am, another sheet automatically print at 10:00 am, another sheet automatically print ...

**1**

vote

**1**answer

2k views

### COUNTIF Duplicate Detection

I have created a formula (excel 2003) to output a "1" if duplicates are found in a column.
=IF(COUNTIF(A$2:A$10750,A2)>1,"1","")
For some reason this formula does not mark the last duplicate in the ...

**0**

votes

**1**answer

7k views

### Excel - Locked for editing by ' '

I am trying to open a file on a network share, when it is already in use Excel tells me :
<file> is locked for editing
by ' '.
Then offers to let me open it as read only.
My question is ...

**0**

votes

**1**answer

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

**1**

vote

**1**answer

430 views

### Source File not updating Destination Files in Excel

I have one source file that holds all my input costs. I then have 30 to 40 destination files (costing sheets) that use links to data in this source file for their various formulae.
I was sure when I ...

**0**

votes

**1**answer

993 views

### How to make Excel application load some xll files via vbs?

I need to be able to load the xlls into an instance of Excel.
It is easy to do so using the GUI. Just use 'open file' dialog box and load the xll file.
However, how I can script this behaviour ...

**0**

votes

**2**answers

732 views

### Programmatically updated a cell's formula in one PC shows #Name in another PC

We have a lot of spreadsheets and there is a need to upgrade an important Addin.
The change will involve converting an old formula to a new one. It is not a straightforward change because the name ...

**1**

vote

**2**answers

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

**1**

vote

**2**answers

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

**2**

votes

**3**answers

176 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

**2**answers

3k views

### Get all linked files to an Excel 2003 document

I want to get a list of all the linked files in an Excel 2003 document, or, better still, automatically retrieve all the files linked to the document and zip them. Is such an operation possible? I am ...

**2**

votes

**2**answers

847 views

### Rearranging a 15 X 25 Excel matrix into three columns

In Excel I have data in cells from A1 to O5 (15 X 25).
I wish to rearrange things such that I have the following
[A1][B1][C1]
[D1][E1][F1]
[G1][H1][I1]
[J1][K1][L1]
...

**0**

votes

**1**answer

335 views

### Microsoft Excel file versions [duplicate]

We have a user here who uses Word 2003 and Excel 2003 as his primary tools. He needs to keep different versions of his files over the time so he can rollback to a previous version at any time. ...

**1**

vote

**1**answer

86 views

### Microsoft Excel 2003 formulas

I am trying to make a formula most of it works this is what I have so far =100%-(D62/C62) this part is great, but if D62=0 I want it to stay 0. How do I add to this formula to work?

**1**

vote

**1**answer

2k views

### How to use multiple criteria with COUNTIF?

INPUT:
This is the format of the OUTPUT desired:
OUTPUT for example INPUT:
The problem is, I don't know how to use COUNTIF with several criteria.
The "dream function" [that doesn't work] ...

**0**

votes

**2**answers

613 views

### Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting
Cell Value is equal to =G7, colour ...

**0**

votes

**2**answers

275 views

### Template is working for Excel2003 but not for Excel2007

I created an Excel worksheet (Book.xlt) under
C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART
with my own setting.
That settings are occurring only for Excel2003(.xls) ...

**0**

votes

**1**answer

1k views

### Disply zero value in cell in excel

Is there any other way to display zero value in excel without using ' before zero.
with zero before ' then it show zero in excel

**3**

votes

**9**answers

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

**0**

votes

**2**answers

436 views

### Properties of cell editor in excel

How to make excel cell editor property as text by default in excel.
Actually cell property is general.How can i make that as text in excel
(Right click on excel cell editor
click on format cell
...

**8**

votes

**4**answers

76k views

### How to open ods files in Excel?

What is the best way to open ods files in Excel 2003?
Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?
The file I ...

**1**

vote

**1**answer

2k views

### How to dynamically link a spreadsheet to another

I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to ...

**1**

vote

**2**answers

8k views

### Link two excel workbook located in different computers

I have two excel workbook
The first one located in one computer (i.e. "\192.168.7.1\Shared\book1.xls")
The second one in another computer (i.e. "\192.168.7.2\Shared\book2.xls")
With both spreadsheet ...

**0**

votes

**2**answers

1k views

### Remove duplicate rows in excel when not all the columns are the same

How can I automatically remove duplicate rows in Excel when data->filter doesn't work, because the columns aren't all the same?
I believe the picture explains what I need, but I can probably supply a ...

**1**

vote

**2**answers

420 views

### How could I get the text defining an Excel formula for one cell into another cell?

In other words, if the value of a cell, say A1, is =Date(), then displayed in cell A1 I will see the date, but then I want B1 to be =FuncText(A1), then I want to see 'Date()' displayed in cell B1.
To ...

**13**

votes

**2**answers

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

**0**

votes

**1**answer

186 views

### How to chart different shifts run times in Excel 2003

I have the following as an example.
Date Duration Shift
4-Dec 60 1
4-Dec 40 2
5-Dec 45 1
5-Dec 55 2
5-Dec 30 3
I am trying to map these ...

**0**

votes

**1**answer

872 views

### Why is Edit->Links disabled when I open my sheet?

I want to use the function to see what other spreadsheets a particular file, says MySS.xls, is linking to. But somehow the 'Link...' is disabled.
I have unprotected MySS.xls.
Why is it so? How can ...

**0**

votes

**1**answer

88 views

### Double-Click URL to Follow in Microsoft Excel 2003?

I want to automatically follow a hyperlinked cell when double-clicked, not single-clicked.
Can I configure this?

**0**

votes

**1**answer

996 views

### Download direct image links in Excel 2003

I have a list of about 6,000 direct links to images in an excel sheet, and I need to download them all automatically onto my computer into a directory keeping the same file names. How do I do this?

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

**5**

votes

**4**answers

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

**2**

votes

**1**answer

127 views

### In Excel, how do I highlight all rows that do not contain “,2”?

I'm verifying the FormatCurrency function is written properly in ASP code and I put everything in Excel from "find results".
I want to highlight only the ones that do not contain ",2" in them.
...