Hi, I am working on an add on which checks a spreadsheet document for potential errors in formulas. For this I needed to identify the cells containing numbers which are included in formulas but the cell format is set as text.
Now, this is done and I need to convert those cells to number cells. It is possible to convert a number which is formated as text using parsing methods. When it is parsed to double it works well, as it behave as a number (It can be subjected to any mathematical function). But the problem is the type of the cell does not change accordingly. It remains as text. I need to change the type of those cells from text to number. Thank you in advance for your kind help. -- Madawa Jeevananda
