Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can I prevent Excel converting to date format?06 Sep 2005 20:33 GMT6
I was wondering if there was a setting or any way to prevent Excel from
converting certain numbers to dates.
e.g. 11/7 will be converted automatically to 11/07/2005. This appears
as 11-Jul in the cell. This problem also happens with 11-7.
Custom # format06 Sep 2005 20:21 GMT1
I would like to display a number * 100, a percentage w/o the percent
sign.  For example, if I type in .55 I want the sheet to display the
number as 55.  How can I do this?
Thanks
Trouble with a keyboard shortcut06 Sep 2005 20:20 GMT1
I am helping a coworker that is having a strange issue in Excel.  
A row of data from an old spreadsheet has somehow been copied, an
every time she hit the "3" key, while in a new or any existing Exce
worksheet, this copied row from the first worksheet is inserted o
Using Relative Hyperlinks06 Sep 2005 19:12 GMT5
How would one set up relative hyperlinks in Excel? For example, if the links
refer to a file system directory, so that the whole hyperlink would be <base
directory>/<variable part of filename>, how could one set things up so that
if the <base directory> were to change, one could ...
Generating run tim error06 Sep 2005 19:00 GMT1
I am wondering if there is anyone that has run into this before. Here
is some code that is in one of my macros.
Sub terr_100()
ChDir "\\dynamics\Documents\Terry\EOD_REPORTS"
Hiding rows that are not grouped06 Sep 2005 18:49 GMT2
I want to hide or unhide all the rows with n/a in column F.  Does
anyone know of an easy way to do that?
Thanks,
Michele
Make Excel default to certain worksheet on startup06 Sep 2005 18:41 GMT3
Just wondering if there is a way to force excel to display a certain
worksheet upon opening a document regardless of which worksheet was
viewed last.
I have a document with about 75 different worksheets and have made a
Add a tick in a cell06 Sep 2005 16:34 GMT2
I want to add a tick sign in a cell, but I don't know where to find a tick
sign.
Anyone can help ?
et
Find all and Sum06 Sep 2005 14:49 GMT2
I have created a worksheet of new/lost and sales moved from one vendor to
another with the associated sales people.
New
     Date Customer Name Type Vendor Premium  Commission SalesPerson
Filter out data06 Sep 2005 13:26 GMT1
i am working on a workbok and have some sheets with a list of data.
This is a product list.
Looks like:
Dimensjon      |  Text      |  Type   |  Number   |  And some mor
Grouping data and protecting worksheets06 Sep 2005 13:18 GMT5
I have grouped a number of rows in my excel sheet so I can collapse the rows
into 1 row.
I then want to protect the worksheet from end users however I also want them
to be able to expand and collapse the group with the small grey plus/minus
Combobox display on startup06 Sep 2005 13:02 GMT5
Hi
There is probably a very simple answer to this but I can't find it...
I have designed a spreadsheet were the end user can select the data to view
by selecting the Year from a range of years and Category from a range of
how to make a picture pop-up when selecting a cell?06 Sep 2005 12:47 GMT1
hello, is there a way to configure a cell such that when clicked,
small window will pop-up, displaying a picture of your choice
--
tendercar
excel search function06 Sep 2005 08:50 GMT2
i created a big excel file with many sheets. in every sheet (except
sheet 1 and 2) is a special id number in column B. now i want to make a
search function on sheet 1 to get  linked to the sheet (cell) where the
number-which i`m looking for, is. how can i do this?
sharing totals between worksheets06 Sep 2005 08:01 GMT1
Hi, HELP! I am trying to create a worksheet to balance our household income
and expenses. What I need to do is take a running total from one worksheet
and have it automatically reflect changes in another worksheet. I don't know
the proper terms for this action. So to try spell it ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.