Questions tagged [microsoft-excel-2003]

The 2003 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
1 vote
1 answer
31 views

Conditional concatenation Excel 2003: if text TRUE, add asterisk

=CONCATENATE(A1)=IF(ISBLANK(F1),"","*") If there is text in column F (not just a blank space), I want to add an asterisk to the value in column A. I only want to see TRUE for H3 ...
Robert MATTHEWS 馬學進's user avatar
0 votes
1 answer
284 views

Count how often value occurs in groups in excel

I have a list of values and want to count how many times values exceeds 400, but if next row values also match this criteria this should not be in counting. COUNTIF formula is of no use in this case I ...
Ranjit Singh Shekhawat's user avatar
0 votes
1 answer
5k views

How to conditionally format if not on list?

Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells). For example, a list of ...
J.P.'s user avatar
  • 5
0 votes
1 answer
92 views

Excel macro to highlight common values between two different sheets

I'm having list of account numbers(AA, AAB, AAC, ADC) in column A in sheet 1 and also I'm having some common account number in sheet 2 (AAB,ADC)which is already available in sheet 1. Now i need a ...
user1092590's user avatar
0 votes
1 answer
165 views

Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)

I have some Excel table which I filled with values since 2004. To sad I didn't include each row add date in extra cell. Now I want to know that... Maybe it still possible? Maybe *.xls file store that ...
Kosmo零's user avatar
  • 195
0 votes
2 answers
784 views

How to insert a line break in a concatenated cell in Excel 2003

In Microsoft Excel 2003, I use the following formula [in cell A2 in a sheet named (Allocation)] to refer to several cells from a sheet named (02Mis) ='02Mis'!$A$4&"/"&'02Mis'!$A$11&"/"&...
Hany's user avatar
  • 229
0 votes
2 answers
234 views

Excel 2003 in Windows 10 - single instance/dde?

I'm running Windows 10 and Excel 2003 (it runs much faster than newer versions of excel). The problem is that I generally prefer most files to open in the same instance of excel. Is there any way to ...
Dave84981654's user avatar
1 vote
1 answer
159 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 ...
Hany's user avatar
  • 229
1 vote
0 answers
392 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 ...
V.Stoyanov's user avatar
-2 votes
2 answers
1k 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 ...
user943449's user avatar
0 votes
1 answer
266 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?
Hany's user avatar
  • 229
1 vote
1 answer
636 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 ...
J. Muller's user avatar
1 vote
1 answer
173 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.
Álvaro González's user avatar
0 votes
4 answers
16k 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
Manikandan r's user avatar
0 votes
3 answers
124 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 ...
Exhausted's user avatar
1 vote
0 answers
69 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?
Sj2507's user avatar
  • 11
0 votes
1 answer
37 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 ...
Achyutha Mohan's user avatar
0 votes
0 answers
108 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 ...
datatoo's user avatar
  • 3,450
1 vote
2 answers
170 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 (...
katmig's user avatar
  • 11
0 votes
1 answer
2k 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$(...
Valerie's user avatar
-1 votes
2 answers
246 views

How can I open a specific sheet named after a month?

I have a bunch of Month Tabs What is one way to open a specific one with VBA? I tried using this snippet: Private Sub Workbook_Open() Dim ws As Worksheet Dim mnth As String, dte As String, mday As ...
Valerie's user avatar
0 votes
0 answers
70 views

How do I make form fill out to different sheets based on the month?

I have an exercise and diet log that I fill out every other day and I want the data to move to another sheet. Sheet 1 looks like a worksheet and I want it to move (I think the best way to do this is ...
Valerie's user avatar
0 votes
1 answer
4k 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 ...
Kevin Wu's user avatar
2 votes
2 answers
21k views

All Borders equivalent in Excel for a range

I would think there is a way in VBA to put the 4 wall borders for every cell in a range, but I have yet to figure out or find one. Basically I want a range such as (A1:R780) to all have their own ...
Crazyd's user avatar
  • 179
1 vote
2 answers
2k views

Is it possibile to enter dates from a drop-down calendar?

In Excel 2003, is it possible to enter dates in a cell from a drop-down calendar instead of entering them manually?
Hany's user avatar
  • 229
2 votes
1 answer
52 views

Hyperlink refers to the new location of the referenced cell

I'm using Excel 2003. I have a hyperlink in cell E4 in worksheet406R to cell E4 in worksheet104S. When I move E4 in worksheet104S to another location (E16) or sort the data in this worksheet, the ...
Hany's user avatar
  • 229
0 votes
3 answers
387 views

Highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") &...
Hany's user avatar
  • 229
0 votes
2 answers
1k views

How to put comma into digits like eastern (especially Indian) style by using a formula in M S Excel?

Friends I want to put comma automatically into the digits like this- 10,00,000 Or 1,00,000 For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,...
ramji's user avatar
  • 171
2 votes
1 answer
354 views

Currency Values Pasted From Firefox Becomes Text in Excel 2003

New here. This is a commonly asked question but cannot seem to find the answer specific to my issue. Just got a refurbished computer Windows 7 Professional 32bit. Installed Office 2003 and Firefox 41....
Andrew's user avatar
  • 41
0 votes
1 answer
239 views

Most recent date for ID in Excel 2003 Pivot Tables

I'm trying to automate a process in our office with pivot tables. I have multiple customer numbers per vin. For my process to work I need a 1:1 ratio of customer numbers to vin numbers. Only the most ...
Alexander John's user avatar
0 votes
1 answer
692 views

How to fill up gaps in excel

My data in excel has for example the following data in columns A and B: A B 1 4 2 6 5 88 9 67 12 45 and so on. I would like to transform it as following: A B 1 4 2 6 3 0 4 ...
user1659936's user avatar
1 vote
1 answer
614 views

Checking column for value. If true, check same row in another column and count if not blank

I have a spreadsheet of employees. Column A is a list of Dept types (sales, HR, payroll, etc). Column B is the date their appraisal is completed, or blank if incomplete. I would like a function that ...
Kevin's user avatar
  • 11
0 votes
1 answer
118 views

How does the user make a selection in MSExcel that contains only those cells that contain data?

Got an MSExcel question for you. he specs for my computer are: Intel Inspiron laptop i3-2.20ghz , 8GB DDR3, 400GB HDD, Win 7 Prem. And the version I am using is MSExcel 2003. My question has to do ...
MercWithMouth's user avatar
0 votes
2 answers
72 views

Excel: Getting #NUM on calc

Why am I getting #NUM error in Excel when trying to input: =((171757/-201011)^(1/4))-1 It works fine on Wolfram Alpha..
MultiformeIngegno's user avatar
1 vote
0 answers
280 views

How to prevent enabling editing in Protected View in Excel 2013 from altering chart formatting of Excel 2000-2003 and 2007-2010 workbooks

In Excel 2013, when opening and enabling editing from Protected View a macro-enabled Excel workbook downloaded from the internet, with two versions in .xls (Excel 2000-2003) and .xlsm (Excel 2007-2010)...
Geoarch's user avatar
  • 11
1 vote
1 answer
2k views

Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this Seems incredible that basic things like this be hard to do in Excel I read this article but it involves other 2 helper ...
serge's user avatar
  • 713
4 votes
1 answer
32k views

Pivot table 'page fields' usage

In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still available. The process starts by pressing Alt, D, P. In one of steps there is ...
ZygD's user avatar
  • 2,487
0 votes
1 answer
1k 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 ...
DaveU's user avatar
  • 111
0 votes
1 answer
46 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 / ...
Lina's user avatar
  • 1
0 votes
1 answer
822 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 ...
James Robinson's user avatar
0 votes
1 answer
2k 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 ...
neubert's user avatar
  • 7,122
0 votes
1 answer
158 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 ...
James Robinson's user avatar
0 votes
1 answer
543 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 ...
Amy Barrett's user avatar
0 votes
0 answers
27 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 ...
Reticulated Spline's user avatar
2 votes
2 answers
211 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 ...
Peter Vermillion's user avatar
0 votes
1 answer
187 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 ...
Peter Vermillion's user avatar
0 votes
1 answer
435 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 column ...
coolguy's user avatar
  • 143
2 votes
1 answer
77 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 ...
RogerC's user avatar
  • 21
5 votes
3 answers
38k 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 ...
davidrsinger's user avatar
0 votes
5 answers
37k 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 ...
Lisa's user avatar
  • 1

1
2 3 4 5 6