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 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
trying to select multiple cells11 Sep 2006 17:09 GMT7
Hello. I can't remember how to select multiple cells in this worksheet.
example I want to select a1 to i11 or something. I need to use the keyboard
for this as I am visually impaired and cannot use a mouse. Thanks.
Formatting when combining text & value in a cell11 Sep 2006 17:03 GMT2
The value of my cell is
="Product Margin is "&Z5
Z5 is 63.6% (in Z5) but 0.63653676693 in my combined cell.  How do I
format the percent when combining text & value?  Thank you for your
Creating a Database in Excel11 Sep 2006 14:11 GMT9
I may not be able to do this, but I figured someone on here could tell me.  I
am a music minister and I am trying to create a list of all the songs we use
in the services.  It will have the title of the song, the temp, key and last
time used and I would like to have a running ...
Rounding problem11 Sep 2006 13:54 GMT1
I have a series of 16 and 18 digit numbers that I am trying to store and work
with.
If for example I have the number 1234123412341234 and I leave the field
unformatted I get '1.23412E+15' which is fine. If I change the cell
First Positive11 Sep 2006 13:28 GMT4
I am trying to obtain the value of the first positive in a column to place
in a summary location.
The column starts with negative values.
I would appreciate help with this question
Rounding problem11 Sep 2006 13:16 GMT2
I have a series of 16 and 18 digit numbers that I am trying to store and work
with.
If for example I have the number 1234123412341234 and I leave the field
unformatted I get '1.23412E+15' which is fine. If I change the cell
Application-defined or object-defined error11 Sep 2006 11:12 GMT1
I find myself stumped by an incredibly easy piece of code and one that I
have used before.
I am getting the error:
Run-time error '1004':
Help with referencing please11 Sep 2006 10:15 GMT18
I'll try and explain exactly how my spreadsheet is laid out and what i'm
trying to achieve.
The sheet is designed to log newspapers and wakeup calls that are ordered by
guests in a hotel.  I have the newspaper side of things working as intended,
macro disabled permanently11 Sep 2006 09:44 GMT1
I interrupted a macro I wrote that went into infinite loop by hitting
ESC. I fixed the macro function which is tied to "Worksheet_Change".
Now it never gets triggered. I put break points in code; not executed
at all. I close/open excel and respond to security dialog as "enable
Exracting numerical data.11 Sep 2006 09:20 GMT10
Sorry, I recently mistakenly posted this to excel.charting.
I recently had to extract the numerical data from  text in
the cells of a fairly long column. Since my problem was
something I don't expect to have to do frequently, I simply
Newbie help question (date and time)11 Sep 2006 09:00 GMT2
I want to add a couple of commands to a custom toolbar that I have
made. I want to add a button to insert the current date in the active
cell and another to insert the current time in the active cell. My
problem is I can't find ANY commands on any toolbar that does those
display order of worksheets11 Sep 2006 08:36 GMT4
I would like to have multiple worksheets in the same book displayed in
a predetermined order whichever worksheet I work on. How can I do this?
autofilter help11 Sep 2006 07:54 GMT3
when i set my auto filter it stops at blank lines rather than allowing me to
select "blanks or non blanks"
the data that it filters doesnt pass the blank line so i  have
dispatched
Would like to display 1-30 in cell11 Sep 2006 06:35 GMT3
Typing in the term 1-30 in a cell always returns the date Jan-30. I
understand date formatting but I would like to display the term 1-30. The
next cell is 31-60 and displays properly. How do I do this. Thankyou.
Don't merge cells?11 Sep 2006 03:10 GMT9
Thanks for your response, Roger.  I am aware of this feature but I can't get it to produce the same effect as merging cells will.  Am I missing something?
Let's say I have Jan Feb Mar ........ starting from A2 and going across.
Above the months and in row 1, I want to include a ...
 
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.