Is it possible to change settings on Excel 2003 so that the answer to
calculations are automatically rounded up or down, according to requirements.
An example of this would be 12.12 * 12.12 being rounded up to 146.90 or down
to 146.89, without using the roundup or round down ...

Is there a way to set up a cell with a specific date format such as
11/30/2007 in which all the person would havee to type is 11302007 and the
rest autofill?
Also is there a way to do the same with time and is there a way to have the

In excel I am trying to open multiple workbooks at once and see the tabs
appear on my screen for each workbook that is open.  I used to be able to do
this and use the alt+tab function to flip between the open books.  Now I am
only seeing one excel tab on my screen for all books ...

I have an excel workbook stored in a shared network drive. One of the sheets
in the workbook has an external link from a csv text file (say
importfile.csv) stored in a different directory in the server. Everything
works fine when I open the workbook and click the refresh data ...

Thankfully and successfully I managed to format cells in Indian rupees like
12,34,567 and so on.
I saved the Blank book as mormal .xlt. But, when I click open the new file (
by clicking the new icon on the menubar) teh customised formats are not

When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
short date regional setting in windows is 11/22/07.  When I go to change the
date format the format that is highlighted is Custom    dd-mmm.  Any idea
where this comes from and how I can change it.

how do i format currency to display 12,34,56,789.00 instead of 123,456,789.00
Please mark placing of Thousand separator .
I have Regional and Language Options set up in my way, but excel still does
not return my way. I have checked "use system seperator" on.

I've just upgraded a small business from Win XP and Office 2000 to Vista and
Office 2007. They have three Vista machines (a Home Premium laptop and two
Vista Ultimate PCs) networked peer-to-peer with a shared folder on one of the
PCs containing various Word documents, Excel ...

Is there any limitation of how many pages you can print in a sheet?
I have a sheet with over 3000 rows, but I can only get the print rage to go
to app. row 2400 - which is 51 pages. Is it possible to extend this?

Language is set to English UK - Laptop and MS Office 2007 bought in Middle
East- dont have problem with other progammes (anymore) but Excel cells go
Right to Left - A1 is top right corner.
How do I change it to Left to Right

When I open Excel 2003, the task pane is across the top of the work area.
How do I move it to the side?
I am unable to pick it up like a taskbar and drag it to where I want it.
Regards

Is there a way to have a default set up, like every worksheet always being
set up in landscape and having wide columns and grid lines showing without
making these adjustments everytime I create a new worksheet?

We are trying to set up an excel spreadsheet that has several check boxes and
we want to set it up to populate the box with an "X" when a user clicks or
double clicks on the cell. How can we accomplish this? Any help will be
appreciated.

hello gurus,
i'm looking for vba code to copy only values and formats to a new
workbook preserving the name on each tab.
thanks in advance

Problem:
I try to open Excel or any spreadsheet.
It tries to open up an installer to install Small Business Edition 2003
I cannot open any of my spreadsheets now.