|
|
#4
08-10-2013, 05:24 PM
|
|||
|
|||
a super easy way to convert a number formatted as text to a number is simply write this formula in an adjacent cell.
=a1+0 Then drag it down copy it and paste the values where you need it. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Vlookup & IF together | thelauncher | Excel | 5 | 08-25-2013 11:32 PM |
 IF and VLOOKUP
|
SBMC | Excel | 1 | 11-07-2012 10:24 AM |
|
Vlookup
|
kkerr | Excel | 6 | 08-31-2012 01:23 AM |
|
Using IF and VLOOKUP together
|
Becki | Excel | 2 | 04-06-2012 05:32 PM |
| Help with VLOOKUP | sakhtar | Excel | 2 | 07-24-2010 07:39 PM |
Windows 7 64bit 
Office 2003
Threaded Mode