![]() Sometimes, it’s also the case when you download data from a database. ![]() A lot of people enter apostrophe before a number to make it text.Now before we move forward, let’s first look at a few reasons why you may end up with a workbook that has numbers stored as text. In such cases, you need to convert cells that contain numbers as text back to numbers. This leads to incorrect calculations when you use these cells in Excel functions such as SUM and AVERAGE (as these functions ignore cells that have text values in it). It’s common to find numbers stored as text in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |