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 / April 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Optimization project26 Apr 2006 15:12 GMT2
I am a novice to the solver function and would be very appreciative if
someone would be able to offer me a solution utilizing solver.
I need to find what is the optimal product mix of the following computer
items given their respective prices, per unit:
excel time format26 Apr 2006 15:03 GMT2
How can i format a cell that will display the ime as 08:00 when i enter 8? i
have tried using the format hh:mm but when i enter 8 the cell displays
00:00:00 and the formula bar shows 08/01/1900 00:00:00.
Mailing Labels to Spreadsheet.26 Apr 2006 14:29 GMT2
I have seen this question before but am unable to find the message.
I have a MS Word document in address label format.  I would like
to convert this file to a spread sheet.  How do I do this?
Thanks
Specified fields26 Apr 2006 13:11 GMT3
Can you predefine options to fill in a cell.  For example I only want people
to able to choose.
01 - Annual Leave
02 - Sick Leave
Work out overtime hours for individuals26 Apr 2006 12:52 GMT3
I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked during the course of a month for individuals (e.g. below)
Name Start End Hours
Floating Excel window26 Apr 2006 12:48 GMT3
Is it possible to make an excel worksheet, or excel float on my desktop so
that it remains always visible.
I want to use it as an adbaced calculator that flost on top of other
applications.
how do i count text and display it as text plus the # times it hap26 Apr 2006 10:15 GMT1
PromotionName    UnitSales    ChannelName    Quarter
Boxing Day    1200    Richard    1                                 1
Boxing Day    1300    Will    2                                 2
Boxing Day    1600    Will    3                                 3
Setting a default sort for a range26 Apr 2006 09:32 GMT2
How do I set a default data sort on a selected range in Exel. I select from
the collumn that the data need to be sorted on. But I have to select
decending all the time and select no header row all the time. All I want to
do is select the range to sort and hit OK.
formula help please26 Apr 2006 09:21 GMT2
Alright I hope I can explain this good enough I tend to ramble...
I have created an "accounting workbook" for my father in law to do his
books in.  He is a farmer, he is late 50's and has only had access or
ever used a computer for the first time last month.  He finally bought
Across Worksheets Again26 Apr 2006 09:09 GMT2
How would I make my name appear in cell D9 on every worksheet in th
workbook with out manually inputting my name into every workshee
(there are 240!)
--
Subtotal Grades26 Apr 2006 07:58 GMT3
I have a list of names with grades blah blah, and have calculated their
number grade. ALso, I used Vlookup and a lookup table to calculate
their letter grade.
NOW:
Applying more than 3 conditional formats26 Apr 2006 06:47 GMT3
I would like to apply a different cell colours to a range based on the cell
value compared with a fixed scale of values.
e.g. values between
0-10 get "green" cell background
Format colorful for a cell (that has formula)26 Apr 2006 03:07 GMT6
Formating colorful for a cell that has formula is posible?
For example: = "I'm " &  1 + 1 & "years old"
And the desired result is: "I'm 2  years old"
So, these is any way for me to do this. Please help. Thanks so much.
vlookup26 Apr 2006 01:55 GMT4
How can I make this work?
I have a worksheet. I need to extract the first two digits of a number. The
two digit number determines which equipment to use.That number checks
against a vlookup table and then the equipment is entered in another cell.
Pivot Talbe Help26 Apr 2006 00:09 GMT3
I've got three columns.
A2:A7000 is customer number.  
B2:B7000 is a circuit ID (unique telecom ID).  
C2:C7000 is revenue
 
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.