changing case #2
Hi, is there any way I can change the letter case in Excel. I know thi
can be done in word by going to format and change case, but am unsur
how to do it in EXcel.
I simply want to change everything to capital letters.
Please let me know, thank you very much for your help.
Message posted from http://www.ExcelForum.com
There is a function =UPPER(A1) but if you want to change all the cells
then use a macro
See this webpages
Here is a Macro for changing text cells in the select...Force upper-case characters?
Is it possible to make any cell display only upper-case letters. So, even if
a lower-case letter is entered its upper case equivalent is displayed.
I know I could simply use UPPER function to display the contents of another
cell in upper-case, but I'm wanting to avoid the need to use other cells.
Any help appreciated.
Try this sub taken from a post by Tom Ogilvy
which will force uppercase in col A:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error goto ErrHandler
If Target.Column = 1 Then
Application.EnableEvents = false
Target.Value = UCase(Ta...Excel 04-07-10
When I type a line in Excel the printing gravitates to the top of the line
and not the bottom. How do I change that?
Format --> Cell --> [Alignment] tab and choose the Vertical Alignment setting
you want: top, center, bottom, justified or distributed.
> When I type a line in Excel the printing gravitates to the top of the line
> and not the bottom. How do I change that?
Format the cells to have bottom alignment in the Horizontal option.
Gord Dibben MS Excel MVP
On Wed, 7 Apr 2010 07:58:01 -0700, patcher
<patcher@discussion...How do I import/open .dbf with large number of fields?
I need to import/open a .dbf file that contains about 350 fields.
When I open it in excel, it only seems to open the first 245 fields
(to column "IU") and doesn't show any fields beyond that. Is there a
way to get all the data for a .dbf with a large number of fields? Is
there an option for this in Excel or a way to do it in VBA?
...Support Email to Support Case
I've only earned about two days of experience with this program so far, so
here goes my first request...
I have the Pro Suite 1.2 version of CRM and I've successfully setup a Queue
User so that all emails that come to Support@***.com are automatically
entered into CRM.
I would like to have CRM automatically create a CASE with this email, or at
least have a CASE created when someone accepts or assigns the email.
Is this possible? Is this something I'll need the Workflow Manager for?
Thanks for your help in advance,
You need www.c360.com's Email to Case module. It...Microsoft CRM 01-17-06
We have installed CRM on our server and can access it from a web browser or
MS Outlook. However it is very slow to loadforms or access any area of CRM -
often taking 5 minutes or more before a page is retrieved. Is this a firewall
We're seeing this as well (CRM 3.0). The performance is inconsistant
-- sometimes it is quite good, other times it is taking upwards of a
minute or two to display a screen. The worst offenders are the Leads
and Opportunities screen.
The system is running in a test environment under Virtual Server 2005
-- could this be impacting thin...make +ve number -ve and -ve number stay same in same column
Budget is our income and sometimes this is positive. I need to make this
column in a query all negitive values.
I am using the IIf function but it is not working.
Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1,
or is there another function I could use?
An iif statement will work - you've got the field in there twice:
Budget: IIf ([budget_amount] >=0, [budget_amount]*-1, [budget_amount])
Alternatively (and perhaps quicker) you could use:
"Tamm Fox" <TammFox@discus...Question on Random number generation
I have a column of numbers, some with money values of 0.00 and others
greater than 0.00. I want to create another column that uses the values from
the first such that if the number is greater than 0, use that numer else
generate a random number between 1.00 and 12,000.00.
How would I do this?
If you want two decimal places, change the last 0 to 2.
Norman Harker MVP (Excel)
"Jack" <firstname.lastname@example.org> wrote in message
>I ...Line Item Restrict to Actual Item Numbers
Is it possible for purchasing and for sales to restrict the line item field
to only use a valid existing item number in the database? We have a problem
in processing that is caused because the system allows them to type in item
numbers that do not exist.
Configure SOP not to accept non-inventory item and and educate user in POP
not to mark Add Item in the options menu when in Purchase Order Entry window.
Otherwise write a VBA script to validate Item Code from Item Master and
Vendor Item Master.
Dencio is correct.
In SOP / POP window option ...page numbering 04-01-10
I want to give page number form the page 4. how to do it
Microsoft Word MVP
"jayesh" <email@example.com> wrote in message
>I want to give page number form the page 4. how to do it
...Change case of text
I have Word 2007. In earlier versions of Word under the Format tab there was
a change case option that made it easy to change selected text to all upper,
I cannot fund this function in Word 2007. Where is it?
Thanks for your help - jjk98
Home tab, Font Group, Change Case "Aa" icon.
Also, does Shft+F3 toggle the text, from no caps - initial caps - all caps?
Hope this helps
> I have Word 2007. In earlier versions of Word under the Format tab there was
> a change case option that made it easy to change selected...saludo 01-15-08
como estan no se como funciona esto
...length of check number
I recently got a new set of paper checks that started at #50000. When I
download the cleared check information for these, MS Money is truncating the
check number - so 50001 became just 1. Is this a known issue? I contacted
Wells Fargo, but they didn't know anything about it. I can edit the check
number and change it to 50001, so it seems to be able to hold that number of
Any pointers/suggestions would be greatly apprecaiated.
I'm betting if you checked the downloaded data, Wells Fargo is truncating it
"Henry Winkler" <Henry Winkler@di...Importing Fedex Tracking Numbers
Has anyone automated the importing of Fedex tracking numbers before?
How did you do it?
"Dan Dan the OTTR Man" <firstname.lastname@example.org> ????
> Has anyone automated the importing of Fedex tracking numbers before?
> How did you do it?
On Feb 12, 8:06=A0am, "???" <136899...@qq.com> wrote:
> "Dan Dan the OTTR Man" <maxwell....@gmail.com> ????news:99be6498-a0a7-4f7=
> > Has any...Find Cases by Case No
Our Tech Dept wants to find quickly a Case by typing the Case No, but the
default Search field for CRM searches by Title, which is not always easy to
guess. Can we do something to change it, either unsupported or no? There is
also the Advanced Find Utility, but can we make a shortcut for our Tech Dept
which will have pre-selected the Case Object and, ideally, the Case No
contains xxx row?
Any ideas will be appreciated.
...Special Formatting of Number Field
I have a column that contains 5 digit numbers (12345) and I would like to
have this column formatted to add 2 leading zeros, then the first digit, a
dash, then the remaining 4 digits. For example, 12345 would be 001-2345. I
would to be able to format this column of numbers automatically, and not have
to do this for each cell.
Select the column and choose Format/Cells/Number/Custom. Enter
in the textbox.
In article <29B63283-62A4-432E-9C32-AE090B4E1601@microsoft.com>,
"weelhow" <email@example.com> wrote:
> I have a column that con...Negelected case alert
I am looking for some help on whether the following is possible?
I want to get email alerts sent automatically to "management" and/or
"owner" should cases be "in progress" for long than x hours/days.
It would appear that this is a fairly standard requirement for most
case management system, but there is no easy way of configuring this in
It also looks like hours, only days are tracked for each case. So does
this mean that even if you do the custom programming, check the age of
the case and invoke the email ection, it would only work on no of days
anywa...Excel Jululian 04-24-10
i have a lists of names and i want to separate each in a colum like
You Light Up My Life197711
You Light Up My Life (in one colum "A")
1977 (in one colum "B")
1 (in one colum "C")
1 (in one colum "E")
First many thanks on your reply
the text are different in length
"מיכאל (מיקי) אבידן" wrote:
> 'Data' > 'Text to Columns' > 'Next' > mark/un-mark the vertical separators as
> shown in the picture > 'Finish'
>...subaccounts opps/cases/contracts rollup
It would be great to have a rollup associated view displaying all
opportunities, cases, contacts and contracts linked to any subaccount (any
number of levels down) of the account you are on.
Currently you have to deal with pockets of sales and service information for
any account that has subaccounts. It is typically an executive type user
that would need a quick overview of everything that is going on in the
national account and you cannot expect this user to go around and check all
subaccounts to get the picture.
This post is a suggestion for Microsoft,...Proper Case
How do Ensure that when a name and initials are typed into a column,
the initials and first letter of the Surname will be converted to
Capital letters if it was not typed correctly. Names in the column
should be entered like this "Black B F" but I often get names in
lowercase or all capital letters.
Can anyone help
To trap thye input needs VBA.
Add this code to the sheet code module (right-click the sheet tab name,
select View Code from the menu, then paste the code into the window). This
is for column A, adjust to suit.
Private Sub Worksheet_Change(ByVal Target As Ran...convert cells to negative number
I have a list of numbers that I need a quick and easy way to convert to a
negative number. I have tried highlighting the numbers and using a custom
format to add the negative sign and parenthesis but when you add the column
up; it is not recognizing the numbers as negative. Any suggestions?
Why not create a helper column to do it?
> I have a list of numbers that I need a quick and easy way to convert to a
> negative number. I have tried highlighting the numbers and using a custom
> format to add the negative sign and parenthesis but when you add t...Exporting numbers into Excel
I am exporting a tab delimited file into excel. The question is and not just
for this project but in general. I have a figure 05 and it always shows up
as 5. How can I get it to display the zero. Excel strips it , even in the
When you import the file, you can specify that that field be treated as text.
Or after you import it as a numeric value, you can format that column with a
custom format of: 00
> I am exporting a tab delimited file into excel. The question is and not just
> for this project but in general. I have a figure 05 an...uml use case
How do I actually start a uml use case diagram. I don't have the option of
selecting On the File menu, point to New, point to Software, and then click
UML Model Diagram. I don't have software as a group under new.
Are you running Visio Professional? This functionality is not part of the
Visio Standard product.
Office Graphics - Visio
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lesviper" <Lesviper@discussions.microsoft.com> wrote in message
Does Excel have a function similar to the "Case" command in other programming
In VBA, yes
Select Case myVal
Case 1: 'do something
Case 2: 'do something else
Case Else; ' exception
(remove nothere from the email address if mailing direct)
"Al" <Al@discussions.microsoft.com> wrote in message
> Does Excel have a function similar to the "Case" command in other
XL itself doesn't, si...picture of a child's school pencil case -colour or b/w
I need a clear clipart image of a child's school pencil case - well I really
need 2, one in colour and one in black and white. Can't find it anywhere
Colour: some examples
I don't know if there are any copyright issues with...