I have complete addresses in each cell.  For example, cell A1 has:
John Smith
123 Main St
Anytown, XX 12345

Hi all….
In excel I am have a simple problem with % number format.
If a number assigned to % symbol  it is multiplied with 100 and giving %
symbol.

My spreadsheet has a calculation that compares material available (both in
inventory and ready to ship to a production facility) to material required
for production.  The ready to ship materials are packed in containers of
varying quantites.  What the following formula is ...

I have a number of surveys where the answers are input by Y/N Check Boxes.  
The Check Boxes are linked into a "Stats" spreadsheet with the True & False
answers.  I need to update the survey spreadsheets for the new period which
means that the cell links need to be changed to a ...

Is there a way to create a conditional, if, then formula that is dependent on
the yes/no checkboxes you can create with the form toolbar?

How do I swich data from being displayed as a column rather than a line in a
Line-Column chart?  I have 6 data series and would like the first 4 in the
chart displayed as columns and the second two as lines using the same y axis,
but right now Excel has defaulted the first two as ...

I have a macro that opens a csv file.  Here is the problem
On my computer the csv files have a ".csv" extention on the end
"filename.csv" but on my coworkers computer there is no csv extention.  So
the macro works on my computer but not on his.

I have a column of numbers, for instance 1.21, that i need formatted to
decimal 9.6.
Any ideas?
Thanks.

In Excel, with the .csv file extension, we have a column of zip codes that
are set up differently for each record.  For an example, we will have 6037,
60371022 and 25463. If we highlight the whole column and select "zipcode",
the 6037 becomes 06037 (like it should), the 25463 ...

microsoft office professional 2003
i have a project schedule consisting of serveral tasks with different
durations for each task. i need to format one cell to show a start and
finsish date for each task and a final cell showing the total duration for

Hey everybody,
I'm stumped here...
Is there a way to set the navigation order of the worksheets when you use
Ctrl+Page Down or Up?

I am trying to edit a previously saved spreadsheet. Many of the cells are
colored, and I would like to eliminate the shading. However, whenever I
select a shaded cell and try to remove the shading by choosing "No Fill,"
nothing happens. I cannot change the color either. If the ...

I've got an issue related to a large datasheet that's being used to
create a great number of 'slice & dice' type reports.  This datasheet
holds (among other things) daily sales data for 30 stores -- so
there's alot of rows.  A data-integrity issue was recently discovered

hi, i need to take an area from one excel and to copy it to another workbook.
i want that the ranges that appear in that area will be included also.
i selected the area, and tried to do copy and insert copied cells, but only
part of the ranges were copied...

I'm using Excel 2003.
I have a protected sheet on which some of the protected cells have comments.
Some of these cells are in the header row of a table with AutoFilter enabled.
Generally comments can be viewed by hovering over the cell. However the