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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Function to indicate the amount of characters in a cell?27 Mar 2006 16:03 GMT2
Trying to do a conversion of data into a flat file.  Using excel we have a
column called Project Description.  
I want to run a function to ensure that the project descrption in each cell
does not exceed 70 characters.
Format Cell27 Mar 2006 13:37 GMT2
I like to acheive this dayte format in a Cell 27-Mar but also in the
same cell ( add text) i.e "27 Mar (Chq)"
At the moment I can only acheive 27/03/2006 (Chq) though the format is
set to dd-mmm in format/custom
Shareing a workbook with one user27 Mar 2006 13:36 GMT4
I have a workbook that I allow read only capability to nine other guys. One
of these guys also needs update capability. How can I set it up to give one
person update capability but the others read only capabilities.
changing color of values bigger or smaller than target27 Mar 2006 13:28 GMT7
My question:
I need to make a list for keeping track whether employees are of aren'
making their targets, wich looks like this:
SUBJECT[/B]                         *TARGET*                    
HELP: text keeps on displaying ##############27 Mar 2006 13:10 GMT2
1. What is the maximum characters an Excel cell can take?
I try to import a very large text string into an Excel cell. I notice that
it's truncated to a certain maximum length.
When I set the cell type to be TEXT it displays #########################
Is a function or a number behind a cell?27 Mar 2006 11:05 GMT1
Lets say that in column A there are several typed in numbers (2, 5, 8 ect)
and some functions that result in a number. By looking at this sheet you
cannot tell wether there is a typed in number of function behind a cell.
Is there a function that i can put in column B that can tell ...
How to count cells27 Mar 2006 09:21 GMT3
I want to put a summary of Job orders in a table. (Excel (Zip) file
attached)
I am having a problem of total.
I want to make a total of only approved job orders not the all job
Cell colours and font colours27 Mar 2006 07:47 GMT8
I seem to remember that when you changed the cell to a very dark colour, the
font automatically changed from black to white.  My font setting is
automatic colour but when I change the cell from no colour to black the cell
contents do not display until I go and format the font to ...
Merging with word27 Mar 2006 07:11 GMT1
Hello!  I'm searching for a way to "link" a cell of information into a
specific location into a MS word document.  I was it was a simple as
using the "=" sign and referencing the information I need like you can
between two excel files.   But I'm looking for a solution for
unable to enter "/" in cell as 1st character27 Mar 2006 05:24 GMT3
Why am I unable to enter the forward slash character (as the 1st entry) in a
cell?
Instead, it appears to act like the ALT key, accessing the File menus.
adding up values on another sheet problem27 Mar 2006 01:56 GMT4
I am trying to do some basic math from the values stored in another sheet,
below is my attempt which brings back an error. Any help appreciated. thanks
=EIsummary!SUM(C9:C15)
=sheetName
changing forumla results to values on the fly27 Mar 2006 01:25 GMT1
Is there a way to get a cell's forumla to convert to its resulting value on
the fly (rather than having to go back in and cut>paste special>values)?
Alternatively, is there a way to use a second column that will display the
values returned from the formulas in the first column as ...
New user with focused direction! Will Excel and VBA do it?26 Mar 2006 23:59 GMT1
First, the background - I am certain a code geek designed Newsgroup format
and sign-up. Take a lesson from Yahoo. (This should seal my fate with the
group.) OK, Debra, I'm here and on my feet, so far. I built my first userform
with Debra's concise tutorial a couple weeks ago. ...
Formatting of data detail on a new sheet from a Pivot Table26 Mar 2006 23:58 GMT2
I have Excel 2003 and have successfully created a Pivot Table which presents
data as I need.  However, when I double click one of the entries to give
details of the entries which contribute to the data, the new sheet that's
created doesn't retain the formatting of the original ...
Link to Internet, copy paste data from Web Page26 Mar 2006 23:51 GMT1
I would like to be able to automate a task of clicking on a link in a
spreadsheet and accessing specific data on a public internet web page
(i.e. Address, City, State, Zip) and place this data into columns of
the linked row.  The data on the public internet web page is formatted
 
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.