Software and Programs Thread, Solved: Conerting Text to number format in Software & Hardware , Games; Hello friends, I have a number of data that were pulled out from an oracle database, where it had entered ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=16824

newbe · 14-01-2009, 10:10 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Software and Programs Thread, Solved: Conerting Text to number format in Software & Hardware , Games; Hello friends, I have a number of data that were pulled out from an oracle database, where it had entered ... Short Link: http://forum.egypt.com/enforum/showthread.php?t=16824