Formatting Cells Containing Date Fields That Are TextSomeone here at work imported into Excel a column of text data that
looks like mm/dd/yyyy form but need to be mmddyyyy. I thought I could
simply highlight the columns, click on Format/Cells/Custom and create
mmddyyyy. I do this but the data doesn't change UNTIL I highlight
each cell and press F2 or double-click in each cell or create a
formula using Right, Mid, etc. When I press F2 or double-click, I
notice that an X and a check mark both appear to the right of the Row/
Column box. There's got to be an easier way to do this besides
'onesie-twosie' but we can't figure it...
Excel chart-y axis title questionEverytime I have a y axis title and it will not show up the end of the title.
I tried to use small font but it doesn't help. Does anyone ever have similar
problem? Thanks.
Many people have reported this problem, and the following post by Jon
Peltier may help you:
http://groups.google.ca/groups?&threadm=OviGl8Z3EHA.208%40TK2MSFTNGP12.phx.gbl
springwinterfall wrote:
> Everytime I have a y axis title and it will not show up the end of the title.
> I tried to use small font but it doesn't help. Does anyone ever have similar
> problem? Thanks.
--
Debra Dalgleish
Ex...
additional exchage in a shared address space / install questionHello Group!
I am about to run out of space on my exchange server, so I came here for an
advice.
I have 3 physical locations
Location 1 - Headquarters (50 Users in the workgroup environment)
Location 2 - Remote Site (10 Users Domain Environment with Exchange)
Location 3 - Remote Site (7 Users Domain Environment)
I have a Gateway to Gateway VPN tunnel between Location 2 and 3. I am in a
single Active Directory 2003 forest with a single domain (mycompany.local)
DC at the location 2 holds all 5 FSMO roles. Exchange 2003 Enterprise is
configured on the same server.
Users from 2nd location run...
Tabbing to non sequenced cells in Excel 2000Can I tab over to only cells that need info input, and skip over other cells?
If you protect the worksheet that will happen.
While holding down the CTRL key, use the mouse to select the cells you wish
to tab through
Select Format/Cells and unselect "Locked" on the "Protection" tab
Then go into Tools/Protection and select Protect Sheet
Now, if you don't use a password, anyone will be able to simply unprotect
the sheet as needed and have the "tabbing" capability.
"cwalton" <cwalton@discussions.microsoft.com> wrote in message
news:1783FC04...
Splitting Cells
Does Excel 2002 allow splitting a cell? I have been asked that
question, and I cannot find the answer on this site. Maybe one of you
can help.
Thanks,
Don
--
DonDavis
------------------------------------------------------------------------
DonDavis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27767
View this thread: http://www.excelforum.com/showthread.php?threadid=472766
Hello DonDavis,
Depends on what you mean by 'splitting a cell'. This can be taken a few
ways. There are some functions which you can use that will look at a cell
and show ...
Simple Question-How to create more than one transaction on the AccIf there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...
Past Questions and AnswersHello
How can I find out past questions and answers for a specific topic? I lost
the answer to my question, which was posted here last week?
thank you
I'd use google. Give it enough information (keywords/author/subject):
http://groups.google.com/advanced_search?&as_ugroup=microsoft.public.excel.*&num=100
da wrote:
>
> Hello
> How can I find out past questions and answers for a specific topic? I lost
> the answer to my question, which was posted here last week?
> thank you
--
Dave Peterson
...
Toolbar dropdown questionHi,
Office XP and Outlook Express will automatically display the double arrow
indicating that there are more buttons on the toolbar when the window is
resized to the point it hides a few buttons of the toolbar. When we click
on this double arrow, a dropdown containing the hidden buttons will pop up.
Does CToolBar have this capability? I have taken a look at CToolBar but it
did not imply anything to the trick. Anyone has a good suggestion? Thanks
much.
TDN wrote:
> Hi,
>
> Office XP and Outlook Express will automatically display the double arrow
> indicating that there are mor...
Adding highlighted cells only -Excel 2000Anyone know if there is a way to add only cells that are highlighted?
I would like to see quick sums of only the cells I have highlighted
and hoping there might be a way to do this quickly and easily. I have
to do this many times with various cells with differing number values.
Thanks in advance
K
By "highlighted" do you mean colored or simply selected?
If the latter, use the Sum on the Status Bar.
If the former.....................
You will have to use VBA to grab the colorindex of the cells.
Do you want to do that?
See Chip Pearson's site for UDF's for working with co...
Blank Cells #3if there are blank cells in a range which i would specify i want to put in
the text "-". what kind of code would i use?
thanks
Select the range, press F5, click special and select blanks, press enter.
type
- and press ctrl + enter instead of enter
Note that if you have numbers in the other cells it is not a good design
using text as well
Regards,
Peo Sjoblom
"daphoenix" <daphoenix@discussions.microsoft.com> wrote in message
news:FEE7427B-C73F-4F6D-970B-8D438C42661A@microsoft.com...
> if there are blank cells in a range which i would specify i want to p...
Excel Cell Formatting, multiple linesVersion: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
Is there a way to force a line wrap within a cell in Excel, similar to the way Shift^Return forces a line wrap in a table cell in Word?
Control+Command+Return as well as Control+Option+Return.
Have a look in Excel Help for others: Keyboard shortcuts used in Excel.
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 5/22/10 1:51 PM, in article 59bb8db7.-1@webcrossing.JaKIaxP2ac0,
"IHS@officeformac.com" <IHS@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (S...
Opening file questionWhen opening a file direct from my documents excel opens
but the sheet does not get displayed. Although if you then
click print preview the content of the sheet is there.
Tried opening excel and then opening file and this works
fine. Not a major problem but annoying.
Any one shed any light?
Cheers,
Ash.
I think xl is trying to help you.
Excel wants to keep the window settings the same way as they were previously.
If you saved your workbook in less than a full window, then the next time you
open it (via double clicking with no existing xl instance running), it will open
it the same win...
seeing the formula (not the cell)Hi All,
Suddendly, I have this strange behaviour.
I have a cell say C3 which contains 2b as a text.
Then on cell I4, I want to se the content of cell C3. on cell I4, I used to
type
=C3, then on I4, I would see 2b. What is strange now, is that on I4, I see
=C3 (the "formula" and not the result). What is more surprizing, is that
on this excell file, I have 2 sheets. On the first sheet, referencing works
fine.
On the second sheet, I can see only the formula.
What do I do to not see the formula, but the resut ? I don't remeber touching
any option.
Regards
Jean Simon
Your cel...
Combined Cell ValueHi All,
I have list in following format:
A B C D E
0 1 2 3 4
Results wanted:
F
"0","1","2","3","4"
One more question is it possible to merge multiple column values into one
column without lost the values?
Thanks in advance.
While you posted in a programming newsgroup, the solution does not require
VB code to accomplish; simply copy/paste the following formula into F1 and
copy it down as needed...
=""""&A1&""","""&B1&am...
Lookup values on a form, trivial question?!Hi everyone,
This is really silly but I have searched everywhere (starting with my "Form
and report design for Access 2007" book) for an explanation on how I make a
form with:
Field A (text box) is INPUT value (customer number), and
Field B-D should (after input value is entered in "textbox A") display more
information about the customer in different textboxes (such as "customer
name, phone number etc")-
(This is just an example, the "customer-information" could be in one or
several different - relational - tables, if that makes a difference...)...
restrict view of certain cells in excelI am trying to restrict access to some users in excel. I am trying to make
it so those that do not have the password can view the sheet "read only" but
cannot view certain cells. Those that do have the password can view all
cells.
Perhaps save as 2 Workspaces?
http://www.ozgrid.com/Excel/save-as-workspace.htm
--
Regards
Dave Hawley
www.ozgrid.com
"Firemann25" <Firemann25@discussions.microsoft.com> wrote in message
news:BA92F134-6CDD-438A-85A8-473AC0F4D57B@microsoft.com...
>I am trying to restrict access to some users in excel. I am tryi...
cell comparisonI am trying to set up a formula in which I have a chart of number 1 - 15 to
equal the number of years service with a company. Beside it is the number of
vaction days for each of those years. Example 1 year-15 days 2 years- 16
days etc.
I have a spread sheet that includes names and years of service based on hire
date. I want to have excel look at the list and from the list find the
number of years and place the number of days in the column beside the number
of years of service in the spread sheet. I think It will work, but I do not
know what formulas to use and cannot understand en...
cached exchange mode questionA user in my organization has Outlook 2003 on her laptop at home. In
order to improve performance I have set it up in cached exchange mode.
when se sent an email last night everything worked fine and the
recipient received it. However, when she checked new emails from home
they did not show up as already read when she arrived in the office.
Also, the email she sent from home on her laptop did not show up in
your sent items box at the office computer. I know this is a
syncrhonization issue, but how can I adjust how cached exchange mode
behaves and make sure that her sent items folder also ge...
2 questionsIn one cell in the SS, I have a comma delineated group of numbers
eg 23,4,5,36,2
Is it possible to determine that another cells contents resides
within this number set?
eg can somehow determine the number 5 (cell g44) resides in this group?
Thanks
In another worksheet we have, we wish to maintain a number of them
as Flat File Databases, and dump 60,000 records in each.
We have "The dummies guide to excel" and I am sure I read that
if set up as a database the limitations are 256 columns/fields
and 16,000 records. Is this true?
if so, why?
Thank you.
Thank you doubleDD,
wo...
Copy row based on cell contentHi
I have a workbook with about 100 sheets; they are all formatted the same as
far as rows, columns, etc. The data in the cells is different.
I would like to copy a range of rows based on the contents of a cell on the
worksheet.
To further explain, I have one of three possible values in cell A1. Based on
this value, I want to copy the range of A5:M13 to another sheet, named the
same as the cell.
I need to repeat this process for all of the sheets in the workbook.
I would like to automate the process because the sheets are going to be
updated often, and I would need to revise this "...
Licensing Question for CRMI have a customer that is a franchisor. He is being courted by a competitor
who is telling him that he can utilize Sharepoint in concert with CRM as a
work around for licensing many users (the Franchisees) for the CRM product.
The franchisees would use CRM to manage their end customers. The vendor is
telling them that it is a valid work around with the licensing agreement
since the franchisees are not actually employees of the company. Does anyone
know if this is possible?
Not a valid work around!
--
Mobitech Lady
Amy Luby
Mobitech
402.330.0707
www.mobitechonline.com
"Tim"...
Run Macro(save workbook) after cell updated
Hello I need a way of saving a workbook after I input something(a user
name) into a cell in column A. I have recorded a macro to save the
workbook I just need it to run when I update one of the cells. There is
a total of 22 worksheets I have to apply this to so f there is a quick
way of apply it to all the sheets that would be even better.
Thanx
Titch
--
titch
------------------------------------------------------------------------
titch's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31190
View this thread: http://www.excelforum.com/showthread.php?threadid=...
question on pivot table
Hi,
Is there a limit to the no of columns allowed to be placed in the ro
area?
Excel XP seems to allow more columns to be added as I encountered
limit when using Excel 2000.
Please advise.
Thanks a lot!!
-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
These MSKB article outline the limits for Excel 2000 and Excel 2002:
XL2000: Limits of PivotTables in Microsoft Excel 2000
http://support.microsoft.com/default.aspx?id=211517
XL2002: Limits of PivotTables in Microso...
Another question about joinsStudents: StudentID, CompanyID
Companies: CompanyID, CompanyName
ClassRegister: ClassRegisterID, StudentID, ClassID
Classes: ClassID, InstructorID, LocationID, StatusID
Instructors: InstructorID, InstructorName
Locations: LocationID, LocationName
Status: StatusID, StatusFlag
Given the tables above (where there is a many to many relationship between
Classes and Students handled by the ClassRegister table), I have been trying
to write a query that will be used in a report with the following structure:
Company
-Location
--Class: Instructor, Status
---Student
I have tried a 100 different querie...
Publishing Questions, Pages aren't being publishedI have designed a site in frontpage 2003, I have saved all my files,
organized them, and created a navigation menu with hyperlinks.
I am having a couple of problems...
( I have hosting with GreenGeeks.com and they have the Frontpage extensions,
which I was able to "install". )
OK, when I publish, I have about 8 pages. The only page that publishes to
the internet successfully is the index page. For some reason, all the other
pages do not publish.
What am I doing wrong?
Tirnanogarabs.com
When you click on the graphic, it is supposed to take you to the actual ...