software

I exported a file into an Excel spreadsheet. One of the columns has a =T( )
function which is preventing me from using the cells of this column for
Vlookup. For example, one of the cells is =T(quot;39601quot;) and the value is
evaluated to 39601. When I try to look this value up in a Vlookup, it returns
#N/A error. When I manually replace it bt 39601, Vlookup starts working. How
can I remove the =T from all the cells? What is this =T function

This is the text function:

Put 1 in a un-used cell
Copy the cell
Select the cells with the T() function
Paste/Special with multiply checked

You will now have a modified formula, but it will be a usable number.
--
Gary's Studentquot;neerajquot; wrote:

gt; I exported a file into an Excel spreadsheet. One of the columns has a =T( )
gt; function which is preventing me from using the cells of this column for
gt; Vlookup. For example, one of the cells is =T(quot;39601quot;) and the value is
gt; evaluated to 39601. When I try to look this value up in a Vlookup, it returns
gt; #N/A error. When I manually replace it bt 39601, Vlookup starts working. How
gt; can I remove the =T from all the cells? What is this =T function