Excel Data Types reference sheet
|
Currency/accounting |
Currency marker. |
|
Dates |
Data that denote a date and/or time. |
|
Numbers |
Data that utilize numbers only. |
|
Percentage |
By clicking on the % icon on the home tab, number section, the % sign is added to the number and the number is multiplied by 100. For example, 0.89 will convert to 89%. |
|
Text |
Data that utilize letters. Letters are aligned left in a cell and numbers are aligned right. |
See also:
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
