At the moment i have CSV files opening up in Excel as a text format ie where
all the data is seperated by a comma and is located in the first column ie  
112,334,33443,,,,12
How do I get the CSV file to automatically open so that the data is in

I notice a few Excel files created by others have this feature that
the first 2 columns at the left will not move when scroll it
horizontally. The scrolling only starts column C. It's great for
column or row with labels. How is it set? How to disable it?

I have rebuilt a machine and failed to backup My Favorites.  I had
previously used a utility (sorry, forgot what it was) to export all my
Favs, all 1334, to a spreadsheet.  The Excel spreadsheet has 3
columns, a title, a URL and the parent directory. These were straight

can I set a cell format that maps values to descriptions?
So that when I enter "1" in the cell it will be shown as "Washington",
when I enter "2" it will be shown as "New York", etc.
Regards,

I have lost my "stop macro recording toolbar" and can not figure how to get
it to reappear.  I know this is simple, thanks in advance for your help.
Jim

Excel 2007.  When I insert a comment the little box that pops up says,
"Preferred Customer."
Where did that come from and how do I keep it from inserting itself in
my comment boxes?

Is there anyway to make a listinng for find & Replace
ex;if=then
out=like
hello=go

When i start Excel, a "Getting Started" dialog pops up.  How can I have
that not pop up?
John

I have a spreadsheet like:
Lot   Slot Cars   Tagged Properly
A       1      2       1
B       1    10      10

hi
i forgot password for my excelsheet. i have so many important things in that
sheet. how can i open the document?. pls suggest me on this..
thanks in advance

I am importing data from our database into Excel.  The database program
stores dates as a string such as 20080124.  I want to convert that string the
mm/dd/yyyy.
Thank you.

I want to collect figures from several worksheets and display them in set
boxes on another worksheet that will act as a template.
I have a sheet with say 50 people on each on their own line. In several
colums their are amounts. I want to move a specific amount to a set static

Is it possible to configure a cell so that a user can enter EITHER a
value OR select from a list of values?  Thanks in advance!

How can I create following function which collects the information from
sheets 2-4 to sheet1? After I have activated Sheets 2,3 and 4, I will give
two parameters on Sheet1. A3 is the header and E3 is the value. It will pick
up the values on Sheet1 on line 2 (green, 6, 76, 2).

I'm looking to the experts on this one as I'm a very basic VBA user
and not sure where to start. I'm looking for some help in buildig a
macro that could do the following. Take a column of data such as below
and then Consolidate the data 50 cells at a time with the data