excel question?

There are three worksheet functions that can be used to change the case of text:

=PROPER() - changes the text of a specified cell to Title Case

=LOWER() - changes the text of a specified cell to lowercase

=UPPER() - changes the text of a specified cell to UPPERCASE

For example, if you have a column of text that is in uppercase and you want to convert it to title case:

Create a new column to the right of the existing upper case text.

In the first cell of the new column, type =proper(xx) where xx equals the cell reference of the adjacent upper case text to be converted.

Copy the formula down for the rest of the column. (The quickest method is to drag the fill handle.) The new column will display the text with initial capitals.

Note: Letters that do not follow another letter will be capitalised. So a capital letter will follow a space, a number and other characters such as punctuation. This may not have the required result. For example, SHOULDN'T will convert to Shouldn'T. However names such as O'Connor will be correct. Names such as MCDONALD will convert to Mcdonald rather than the generally accepted McDonald.

this could ensue if the cellular is formatted for dates till now you enter the value. attempting to alter the format whilst there's a cost interior the cellular won't help, via fact a different inner value is already getting used via Excel. (some human beings write their dates that way, so Excel obliges. uncertain the form you purchased 42345, via fact the quantity 41078 is how Excel internally represents the date June 18 2012.) The cellular must be generally or quantity format *till now* coming into the quantity you desire.

PROPER(text)