I recall that I could precede a value in a cell with some character and then
the value would repeat for the width of the column.
Is there such a character? If so, what is it please?

I need some help as I can not get around my problem.
If I use a Combobox on the sheet with 4 rows the linked cell shows the
number of the row selected but if I do the same in a userform with a
combobox the linked cell writes out the text instead. I can?t figure out how

I have several excel spreadsheets that list the contents of a drive by
file name, path, size of file, extension and a few other things. I can
sort the file extension column to see a general list of the files of
each type but I was wondering if there is a simple way to (1) list all

Does anyone know how to do this?
I want to write sum simple maths times table quizzes for school children.
If they input the correct answer I want to find a way of making a tick or
something appear in the adjacent cedll to te answer of a cross if the answer

Need some urgent help please. Thanks in advance.
How do I round to the nearest thousnad and nearest
million in Excel.
£1,000,000 would show as £1000k

This is the first time I am posting to this newsgroup and if it is not the
right place for my question, please point me to the correct newsgroup.
I am trying to form an 'If' function to say: 'If a cell is not empty, enter
a 1, otherwise enter a 0'.  Does anyone know if there is a ...

1.for excel VBA programming, how to get the row value and column value of an
active cell ?
2.   if XX="YYY" then XX=10, if XX="iii" then XX=8, if XX="ooo" the XX=5,
if......

I have a frustrating formula which seems to be right that is giving m
a #value result.
Here goes:
I have 23 sheets in my 1st workbook (Attendance) relating to eac

Running XP Pro Sp1, Office 2003 Sp1.
We have a few pc's with the above installed. When the machine is freshly
rebooted the user can print from excel a few times successfully but then
nothing is produced. Nothing shows in the print Queue. The 'Printing page 1

All of the sudden, when I enter a formula into a cell, for example a
percentage
conversion for currency exchange (eg =a1*.7647) and try and drag fill for
a2, a3 etc, the actual calculation for a1 appears in the fill cells, not the

Hello, I'll try to explain my situation the best I can. I have Excel 2003.
On the bottom of my sheet there is this task line ( I don't know how to
explain it in English) where you see for example if you have caps on or not
and on the left you see the word "ready". What my problem ...

H ithere,
Can someone please help me?  I have a column which can only have
option (due to validation), these are:-
 New

In my spread sheet I maintain a great deal of information regarding our
fleet, I would like a way for the spread sheet to automaticaly calculate the
payoff amount based on either "TODAYS" date or a date that I imput. Currently
I have set up the "LOAN CALULATOR" spread sheet for ...

Select Case Cells(2 , 7)
    Case 0
        zwch = 5
    Case ""