Some times we have may have to work on large database and find that some of the data is still stored as "Text" even if we format entire range to Numeric by selecting entire range.
When we select such cell, window pops up and says "The number in this cell is formatted as as text or preceded by an apostrophe". We can convert these cells to Numbers by selecting drop down menu.
Question here is that when working on large data and having such cells in between, it becomes very difficult to convert each and every such cell to numbers.
Is there any simple way to format entire Range as "Numeric" including above type of cells and not converting one by one. sample file attached..
Regards,
Kundanlal
Bookmarks