Docstoc

excel-formula-functions-text-date

Document Sample
excel-formula-functions-text-date Powered By Docstoc
					Original Value            LOWER()                 PROPER()                 UPPER()
edith ABBOTT
grace ABBOTT
vittoria ACCORAMBONI
abigail smith ADAMS
annette ADAMS
hannah ADAMS
jane ADDAMS
maya ANGELOU
katharine susan ANTHONY
susan brownell ANTHONY
corazon AQUINO
marie ANTOINETTE

                          Try the functions above and see how they work…
Full Name              Length   First 3 Characters Last 3 Characters
Edith Abbott
Grace Abbott
Vittoria Accoramboni
Abigail Smith Adams
Annette Adams
Hannah Adams
Jane Addams
Maya Angelou
Katharine Anthony
Susan Anthony
Corazon Aquino
Marie Antoinette
Where is Space?   First Name   Last Name
                                  October 30, 2005
                                   March 20, 2005


Difference as a number of days:
Difference as a time interval:
                                                 4:30:12 PM
                                                 2:35:40 PM

Difference as a time:                             1:54:32 AM
Difference as a time interval:                        1:54:32
Difference as a number of days:                 0.079537037
Difference as a number of hours:                1.908888889
Difference as a number of minutes:              114.5333333




                                     Look at each cell's formula and cell format
                                     How do they differ?

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:8/26/2012
language:Latin
pages:5