I have excel 2003 and when I try and slide the date column over
to get ride of the seconds in it, I get garbled lines.
How can I slide it over to get ride of the seconds & keep the lines
from showing up & keep just the date.

I use a PC with office 2000 and have recently acquired a laptop for use on
hols etc, the laptop has Microsoft works Spreadsheet already installed. I
dont want to go and use up unnecessary harddrive space so are the 2 systems
compatible should I need to transfer one to the other? I ...

I have formatted 2 cells say A1 and B1 as time and chose the first type
being in the form 13:30 - This shows up in the equation line as 1:12:00 PM.
So I type in 13:12 and I get what is required BUT is there a way that I can
type 1312 without having to put the ':' in? and still ...

Today i have a great opportunities to share with u.
http://www.12dailypro.com/?ref=122901
http://www.surfsquare.com/?ref=6907
This 2 programs already paid me again & again. Please visit their FORUM

I've been looking for an Excel s/s that will perform financial ROI's,
including periodic additons/withdrawals, such as the online app found at
http://cgi.money.cnn.com/tools/returnrate/returnrate.jsp.
I've searched high and low to no avail.

Excel 2003 - HELP ASAP PLEASE - I need Excel working ASAP.
I know this sounds like a hardware problem but all other programs (inc.
other spreadsheets) work fine.  Whenever I start Excel (new or existing
file) it is as if the 1st place I select (tab or cell) is as if I am holding

Rotor  Mode  Gauge 1    Gauge 2    Gauge 3
0          1             1            4            4
0          2             6            5            5
0          3             8            4            7

I'm very new to excel and i think i just don't understand a basic function
but i couldn't find it under the help menu.
how can you define a cell using a letter and then a value of another cell?  
here is an example

Quick question....
If I have a VBA saying
ActiveChart.SeriesCollection(1).Values = "=three!R3000C11:R4000tC11"
can I replace it with

If I don't have the correct Newsgroup for this problem please let me know
where to look for this following advice.
I'm having a strange problem.  I have a floppy disk on which I keep my
addresses.  I also have other spreadsheets on the same floppy disk.  The

I have recorded a Macro to import a Text file and then sort it
When I try to use the macro using the Keyboard shortcut the macro stops
after importing the file - ie it does not do the sort
However if I step through the Macro using F8 it works OK

Newbie
Is there an action to automatically fill a series of dates?
Row A1 01/01/2006
Row B1 Blank

As the topic suggested I need help.
Lets say I have a numeric value in cell B14 on Sheet3. The value i
generated by COUNTIF from two other Sheets.
What I need to do is change the color of the value when I chang

Hello - Newbie question:
I have an Excel file (98) with 1600 names of people
Each name is a link to their personal file
I need to know how many of the links point to the 'under construction' page

   There are 2 worksheets (Sheet1, Sheet2) containing similar data in my
workbook. I want to underline the text in a cell in Sheet2 if the text in
that cell is the same as the cell in the same place in Sheet1. (For example,
if Sheet1!A1 = Sheet2!A1, then Sheet2!A1 is underlined ...