In a workbook containing a number of sheets all are set not to display zeros,
but if I open a new window to view different sheets of the same workbook side
by side the sheets in the new window are displaying zeros and I have to go
into options to change that back.  Any ...

hi community
can anybody kindly assist me in this..
i plotted a data for 5 days (workdays - Monday to Friday) and when I
selected the tabulated and plotted a chart (line chart)

Good Evening Everyone !
I'm Miki and using Office 2k3 and is facing problem while using protection
in excel.
I have some formulas in my worksheet and I want that nobody can see the

My document will not print or preview with background color. All printer
properties are correct. It was copied from 2002 excel to 2008

A1 = Street number like 1234
B1 = Street name like lake wood drive
I want all records to be sorted by street name (B1) and then the records
with identical street names, to be sorted by their numbers, A1.

how can i remove or killed 5 digits from right side of a string ?
JN1BAUJ31Z0001807 >>> JN1BAUJ31Z0
GM6BK1061012056 >>> GM6BK1061
thanks in advance

I am trying to create an org chart in Excel.  Each box in the chart will have
a department, the number of employees and a budget amount.  The numbers and
amounts will change with each hew fiscal year and even sometimes throughout
the year.  Is there a way to have the chart on ...

I have an Excel 2007 spreadsheet with a Pivottable in it.
I want to give it to a person that has Excel 2003.
I have saved the spreadsheet in an Excel 2003 compatible file and given it
to the other person.

I have a workbook that I started and I have since shared it with others.  I
have numerous rows and columns thati have hidden.  It seems that every time a
new user opens the workbook and saves it while I have it closed, the next
time I open the work book it unhides all rows and ...

I need to get the current Excel version in a cell, if I use =INFO("release")
I get 10 or 11.  Is there anything that will give me "Microsoft Office Excel  
2003 (11) SP3" in  a cell as it shows in "About Microsoft Excel" from menu?
Thanks

I saved a list of friends personal email addresses  to an excel spreadsheet.
Now I wish to to take this list email my friends. I have approx 200
addresses(names).  I know in AOL, Yahoo etc. You need to place commas after
every name in order for it to reach the recipient.   How ...

Another user, Andy Pope, helped me fix a problem I was having in Excel by
instructing me to use an "Add-in".  When I download the add-in and use it to
open an Excel file, it works great.  However, if I close the file, the
additional function provided by the add-in goes away on ...

I'm currently using Excel 2002.  I have a list of names, addresses, phone
numbers and other info.  I was trying to make it so that when I input a
search criteria, I could get back a result or a list of results depending on
the input.  Access might be a better choice to use for ...

How do I create a unique dropdown from a list of values in another column
most of which occur more than once
Thanks in advance

Is there a way when a formula is 0 that it will leave the cell empty instead
of having the 0?  I have a bar chart with a lot of information/values and
most of the time there is no value (0).....but the charts data labels all
have the 0's and it looks really overwhelming.   If ...