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 / July 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Count characters18 Jul 2007 20:10 GMT4
Does anyone know of a formula or function that will look at a cell and tell
you how many characters there are in a cell?
Thanks in advance!
Dates showing as serial number18 Jul 2007 17:40 GMT3
I have an excel sheet that has all the dates showing as serial numbers.  For
example...  8/24/2007 shows as 39318  and 6/27/2007 shows as 39260.  I have
tried changing the format of the cells but it stays as the number and change
to the date.  Help please.
transpose skip zeros(0's)18 Jul 2007 17:23 GMT2
I am trying to transpose a row into column. I want the column to take
only non-zero and non-blank values,e.g.,
1 blank 2 0 blank 3 4
after transpose
Convert number with comma to number with dot18 Jul 2007 17:08 GMT2
Is there an easy way to convert "1.12" to a number, if your system is set  
to use the comma as a decimal separator?
The value() function does not appear to take a format or locale as  
argument.
Find/Found18 Jul 2007 15:10 GMT1
Can not get Found to respond. Object: Get PersonName in Sheet2, Go to
Sheet1, Find PersonName. If Found put PersonName & address into Sheet2
Else put PersonName in Sheet3. Sheet2 has no address. Sheet1 has most,
but not all names that are in Sheet2
Why #NA when using VLOOKUP?18 Jul 2007 15:09 GMT8
I'm trying to use VLOOKUP to find lowest value in a small group.  The exact sample is below:
         A       B
     1  3.0001    A
     2  2.9442    B
Update name range18 Jul 2007 14:40 GMT2
I have about 50 Excel files in a folder call "Import Updates".  Within all
of the Excel files I have a sheet call "Table"  The user will populate the
columns A - E each month. The number of rows varies, within the Excel sheet,
there is a name range call "DataImport".  The user ...
Validation18 Jul 2007 14:24 GMT1
How can I create a vba code to make a validation in a excel's cell?
This validation must be the datas from a field in one table in ms
access.
Thanks,
strings18 Jul 2007 14:09 GMT1
In, Id like to write a macro to look at a cell to see if it contains a
particular word. eg if  i had " Id like to write a macro to look at a
cell " in   a1, and i want to see if the sentance contains "macro".
How would I go about  this. I know how to move through the cells just
Add new line in a cell18 Jul 2007 12:00 GMT2
I must be suffering from oldtimerers disease but I can't remember how to
to add a new line inside a cell.
I have tried various combinations of alt, shift, ctrl, enter but I can't
get it.
SQL instruction18 Jul 2007 08:51 GMT1
I don't known nothing about SQL - it's my big problem in excel!
Now I'm trying to import some datas from ms acess whith some
criterias, but I don't know how to create a SQL instruction.
I did a form in excel with two textbox: txtgm and txtdate - the user
Excel 2007 sorting bug?18 Jul 2007 08:17 GMT6
If an Excel 2007 sheet (#1)  has formula referenced cells to another sheet
(#2),  and if the column in sheet (#2) containing the referenced cells is
then A-Z sorted on the value then the original references in sheet #1 get
lost as they are now pointing to different cells.
in excel useing comments how do you add clip art to comments?18 Jul 2007 08:14 GMT2
in excel useing comments how do you add clip art to comments?
How do I create a timetable I can update easily18 Jul 2007 08:12 GMT2
I need a timetable I can call up on my computer and adjust easily as classes
change
Numbering worksheets using Auto Fill18 Jul 2007 07:44 GMT2
Is it possible to number worksheets using Auto Fill Method?
Your assistance will be appreciated.
 
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.