I have a spreadsheet that the data, the date was input in Excel 2003 as
mm/dd/yyyy (12/31/2004), how can I convert the column of cells format to
"dd:mm:yyyy"(31:12:2004)? I tried to change date
format from  "Format Cells----choose "date" or "custom" and tried different

Below is the chain of questions that I still need answers for.  I am new
at the time formatting, ascending or descending times, converting time
and how to identify shift start and end so excel can read it.  As you
will read I NEED HELP.

how can i have pivot source as mutilpe sheets? As i have my pivot source
data to be more than 65550 rows , which will span acreoss multiple sheets.
Its not multiple consolidation sheet option, as it does not provide
selection of column and row areas.

When typing in a cell how do I get the text to drop down a line yet stay
in the same cell?
ie.  In word you hit enter and the cursor drops to the next line.  In
excel you hit enter and the next cell is selected.

I am currently trying to create somthing, I dont even know if excel i
capable of doing it however.
Basically I have a main page (Sheet 1) with a list in Column A wit
building sites. Currently it goes from A10-32. Now each of thes

I know how to add a dynamic range with a fixed point by doing
=SUM(INDIRECT("E14:E" & ROW()-2)),
my problem is that i need to dynamically add a range without a fixed
point.  Is this possible to do with an excel formula, becuase I cannot

Hi - I have a fairly wordy excel sheet and I am trying to format it such that
any time a 'defined' phrase appears, it is in Bold.
I tried the search and replace, and had the 'replaced' word in bold, but it
makes the entire cell Bold, not just the word I did the find and replace on ...

Hello, I have a situation where I want to move 3 sheets from on
workbook to another.  The Problem is that the sheets appears to carr
their File Path with them creating a Problem for my formulas within th
destination sheet..

How do I change the zero to a zero with a slash
through it.
Will this work for all Office programs (i.e.,
Word, Access,

hey I was wondering if there's anyway to disable that horizonata
"snapping" that happens with the columns. It's especially annoying if
want to have a column wider than my screen, since it doesn't let m
scroll over it instead jumps to the next column and I can't read th

I have a question about autocoloring cells, rows, columns, etc.  This
is not about conditional formatting - it's about, for example, coloring
every other row automatically per some function or style setup.
The example I have is a row-based database of recruiters.  As my

Sorry if this is posted in the wrong fourm but heres what I am trying to
do:
I need to set up a spreadsheet, i've got the basics down (I think) but
am having some problems what i am trying to do is:

when I type a date into a cell, it automatically converts it to a date-time
variable
and formats it according to the system parameters.
Is there any way I can turn this off? I don't want my date as a date time

Moving an entire row within a sheet in Excel XP is implemented
correctly:
Select the entire row, cut it, go to the target location, and Insert
Copied Cells. The target row is inserted (pushing all rows below it

Hi  Im newish to excel so maybe there is a really simple answer I a
overlooking or maybe it is not possible with excel but here is what
am trying to do.
I am trying to figure out a way scan numerical results in a column bu