In modern Excel, a single cell can contain multiple fields of data. This is possible thanks to data types in Excel. These data types are often referred to as rich data types to distinguish them from existing data types such as number, string, and Boolean.
We will begin this chapter with a short explanation of the different data types available in Excel. We then get down to the purpose of this book and learn how we can use formulas to access and perform calculations on data type fields.
This chapter is not intended to ...
