Using Excel I formatted cells using fractions as quarters. how can I convert
the 2/4 to 1/2 now?
all of the numbers of my cells now show either 1/4, 2/4 or 3/4. I wanted to
be able to change the 2/4 for 1/2 without having to format each one. Thank

I have 2 columns of data.  One column is an account #, the second
column is the amount spent in one transaction.  So I have dupes in
column A, values I wish to keep and tally in column B.
I would like to construct a macro that tallies the amount for each

Bonsoir
je recherches svp un site tres complet traitant les tcd notament les
éléments & champs calcules
Merci & bonne soirée

I have a large spread sheet with normal black fonts i do not wish to display.
So I would like to filter the spreadsheet by red font and blue font.
Is this possible?
Regards

Does anyone know how to set own format in cell for numbers
have a number 4305605 and want 4.305
i.e numbers in tousand and a sign for tousand too or space like 4 305
I'v tried this   #0(space);[Red] #0(space)    and only get 4305

How can I automatically have the following things happen when the user opens
a workbook:
1) Check the Add-in "AnalysisTool Pak" box so it is accessible to the user
(accessed manually via Tools > Addins).

I have references on sheet 1 column A and I have part of these references on
sheet 2 column A as well. On Sheet 1 column B, I want to put "Yes" for
references on sheet 1 which match references on Sheet 2 and "No" for
otherwise.

I am working with a spread sheet and I need  both the Formula Auditing
and Reviewing Toolbars but I am unsuccessful in summoning   the
Reviewing Toolsbar.  I have tried displaying the Customize Dialog Box,
then ToolsTab and have Standard, Formating, Fomula Auditing, Reviewing

I have a spreadsheet that I wish to protect so that its contents can be
viewed but not altered or copied by the recipients. I have set passwords for
the worksheet and the workbook and against the modify in tool options.
However it is still possible to select the entire contents ...

Hi. I'm using Excel 2007. I have a row with a cell that contains a number,
say 4444.  I want to select this number and drag down so the following cells
below this row and cell with a number with appear as 4444.1, the next row and
cell below this as 4444.2, ... 4444.10, 4444.11, ...

I always encounter an error message when i copy a sheet from one workbook to
another workbook.
The error message is as below:
================

Someone put the following formula into a spreadsheet that I have to maintain:
=ABC!H14:ABC!H18+ABC!H24
I understand the use of : to pass a ranged to a function, but this does not
make sense to me.  It only adds the values from H14, H18, and H24.  Is the

I have a geocoding program that requires me to save my spreadsheet to a db IV
file in order to import it into the program and process.  The problem is
this:  I have to set the column with zip codes to a required fixed width of 5
AND it must be named "ZIP".  I set the width to 5 ...

Hello.  How do you code a macro so that you can pop up a file dialog screen
to open a worksheet from any folder of your choice?
Thanks in advance.

I was hoping someone could help me. Say I have a simple web form,
consisting of one text field. How can I get the contents of that text
field into a cell in my spreadsheet? For example, lets say, I type my
name "2eXtreme" into the Google search bar, is there any way I can run