Number Utilities

Number -  Convert text number to numbers                Sometimes when you download data from another System like ERP package, the numbers which appear are really not numbers but are text. You can check this with another function under "Miscellaneous" Check for cell content is number. If you find that the data is Text and you want it to be a number then just select the range and use this function to make the text numbers to real numbers. Also if a number is prefixed with a ' then also it is a text number and this program will remove the " ' " and make it a number. There may be cases where a zero before will get removed when you convert a text like "05144" to number it will obviously become 5144.

Convert Numbers to text numbers by adding '.                With this function you can convert any number to text by prefixing it with a '. This is specially required in queries and lookup formulas in Excel. First select the Range whose numbers you want to convert to text then use this function to add a ' (apostrophe) in front.

Shift "-" from end to front                When you download Data from other Software like ERP packages or Financial packages, the negative numbers are formatted in such a way that when the data is opened in Excel, the negative numbers have the "-" (minus) sign at the end. This results in the number becoming a Text and cannot be further used in mathematical calculations unless you move the "-" from the end to the front. Manually doing it for a large database is mind boggling. However with this function just select the range within which such erroneous data is there and select this function. In a Jiffy the data will be corrected to show the negative figures.

Select Cell with highest Value in selected Range If you want to find the Cell with the largest value in a range just use this function.

Select Cell with Lowest Value in selected range If you want to find the Cell with the lowest value in a range just use this function.

Convert Indian Rupees to Text With this function, any number signifying Indian Currency in numeric form can be converted to the text form and the data will be placed in the right hand column eg  1235.25 will be Rs. One thousand two hundred thirty five and twenty five paisa.

Convert Indian Rupees to Text formula This is the dynamic formula for converting any number signifying Indian Currency in numeric form to text form. Use the formula =num2text(Cell address or number) . This can be directly used in any cell referencing the number appearing in another cell. for example.