It’s important to format the cell correctly so that numeric data will work correctly in calculations. When displaying data in reports text data will be left-aligned and numbers will be right-aligned.