Hello friends, I have a number of data that were pulled out from an oracle database, where it had entered in text format. In fact it contains both numbers and text. Is it possible to convert all numbers that entered as text into number format?...
Hello friends,
I have a number of data that were pulled out from an oracle database, where it had entered in text format. In fact it contains both numbers and text. Is it possible to convert all numbers that entered as text into number format? It is required for calculation in Excel. When I tried by selecting and changing their format, it is not happening. It works only if re-enter that number in that cell. Any remedy?