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 / General Excel Questions / March 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
In a data merge, how do I get 12.5 to transfer as 12.50?29 Mar 2008 23:05 GMT1
I am doing a data merge from excel to publisher and I need the data to
transfer over as 12.50 but it will only transfer over as 12.5. I have changed
this in format cells but nothing seems to work. Any help would be
great!!!!!!!!!!
conversion help29 Mar 2008 23:01 GMT7
Does anyone know of a way to convert *.QIF or *.QFX files (from the bank) to excel?
Thanks
Signature

Live simply...Love generously...Care deeply...Speak kindly...Leave the

Cannot Autorecover. Downloaded Autosafe. What now?29 Mar 2008 22:54 GMT1
This has been the umpteenth time that I've lost data because Autorecover
cannot be recovered on my machine. The Help menu instructs me to access the
recovered file by going to C:\Documents and Settings\my name\Application
Data\Microsoft\Excel\.
How to change a pasted web link to hyperlink29 Mar 2008 22:33 GMT1
I have designed a worksheet wherein the cells contains the following
information
The webpage address link
A summary of the page to which the link points
Need to insert a workable document into excel29 Mar 2008 22:32 GMT3
My company has an Excel file we use that has forms on individual tabs.  These
are standard forms we use with all of our customers that allow us to fill in
information on them and print them out without having to constantly open
individual documents.  We just go tab to tab to tab, ...
VBA Tab question29 Mar 2008 22:18 GMT3
The following code allows me to type a Name in B2 of a new worksheet in two
other woekbooks, but not in a new (third) wookbook.  Simply put, when a name
is typed in B2 the Tab is named the same as B2.  
Now it does not work in a third Wookbook, new Worksheet
How do i change the default color for selected cells in excel?29 Mar 2008 20:09 GMT4
i have recently changed to Office 2007. Now when I select cells, specifically
rows that I want to delete, I click on the row number but the color of the
cells doesn't change significantly. It is difficult to see if the cell is
actually highlighted. Does anyone know how to change ...
Custom filter date using VB29 Mar 2008 20:05 GMT1
Hi
I am running a macro to select rows from data using filter of certain
fields. It works fine for the fields where I have to searching for specific
text eg
converted spreadsheet to 2007, column letters now numbers??29 Mar 2008 19:57 GMT2
In a spreadsheet converted to version 2007, the column letters changed to
column numbers.  The rows and columns are now identified with numbers.  I
have never seen this in a spreadsheet and am wondering if this can be
converted back and why it happened.
How to copying conditional formatting using the fill handle.29 Mar 2008 19:45 GMT2
I'm trying to find a way of copying conditional formatting to adjacent cells
similar to using the fill handle when copying formulas from one cell to
another.
SMALL/LARGE and text29 Mar 2008 18:50 GMT4
I know SMALL and LARGE don't work on text.  Are there alternate functions
that could sort text and find the x-th smaller/larger "value" among the cells
of the range?
Wrap Text Evenly in Cell29 Mar 2008 17:48 GMT1
I have the following formula:
=ROUND(INDEX(Trend,$A7,3),3)*100&"% Avg / "&ROUND(INDEX(Trend),$A7,5),
3)*100&"% Man / "&ROUND(INDEX(Trend),$A7,6),3)*100&"% Net"
Which I'd like to wrap after ever "/"  in the cell.
Protect sheet but hide rows?29 Mar 2008 17:24 GMT7
I have a large spreadsheet that is used as a tool by many people, the
formula in the spreadsheet have to be protected to prevent them being
overwritten or deleted by users however I would like the users to be able to
hide or unhide rows/columns. When I use the protect worksheet ...
Sorting data from one sheet to another29 Mar 2008 17:14 GMT1
Dear Senior members, i have a data containing on about 10,000 rows which
consists the following heads S.No.  Name of person, Address, Telephone No.
and mobile No. I have to sort out this data on the basis of areas which is
divided into 5 catageries on the basis of addresses. ...
If formula---adding another condition29 Mar 2008 15:50 GMT6
I have this formula already set up:
=IF(TODAY()<DATE(2008,3,1),"",IF(COUNTIF('Employee
Attendance'!12:12,">="&DATE(2008,6,1))-COUNTIF('Employee
Attendance'!12:12,">="&DATE(2008,7,1))>0,"No","$25.00"))
 
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.